Revise Formula - RYG

Nana250

I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red")

However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.

Ryan Kramer

Give this a shot -

=IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", IF(CONTAINS("Specific Word", [Column 3]@row), "Yellow", "Red"))

Ryan Kramer

Give this a shot -

=IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", IF(CONTAINS("Specific Word", [Column 3]@row), "Yellow", "Red"))