If status is open and risk is high then X

jcostoplus

I'm trying to create a formula that references two columns (Status and Risk Rating) to display the "no", "hold" or "yes" symbols. If the Status row is open AND the Risk Rating is High/Medium/Low, etc... I have the formula to work if I am just referencing risk rating IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes"))

I would think the formula would be =IF(AND([Status]@row = "Open", ([Risk Rating]@row = "High", "No" and so on... but it gives me the unparseable error- any advice?

Antonio Figueroa

The formula is the right one you just have to Close the and statement before you finish the If Statement. See Below

=IF(AND([Risk Rating]@row = "High", Staus@row = "Open"), "No", "")

Toufong Vang

You don't need the AND() function.

Your IF() statement for evaluating risk_rating (corrected) is

IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes")))

...which works just fine.

You're adding one more condition when Status is 'Open' so the structure of your formula would look like this...

IF( [Status]@row = "Open", your_statement_for_risk_rating , value_for_when_status_not_open )

jcostoplus

Thank you so much!