I am trying to compare text in two columns to auto calculate a result in a third calculated column (represented by an image).
The logic is as follows.
If column1 value is Green and Column2 is Yellow - then I want to display a down arrow image.
If column1 is Yellow and Column2 is Green - then I want to display an up-arrow image.
.... and so on, with various examples.
Just to experiment, I tried to write the formula for the first example, but keep getting syntax errors. Any chance I can get help to debug and figure out how to include multiple options in the same formula?
Here's what I came up with (which produces syntax error).
=IF( ( [Prior Status]="Green" , AND( [Current Status]="Yellow" ,"<img src='https:---URL HERE---down.png'></img>")`
Am I even close? I am not a programmer, and don't really understand the nuances of syntax, but like a monkey I can learn and copy :-) - with some guidance.
Thanks in advance for any help you can provide.