IF statement with a OR statement

PCC87

I have a IF statement setup in a cell to look at another cell's value to trigger a status color using the RYG icon. I also have another column labeled Urgent with the "flag" icon. I would like if someone selects the flag in Urgent that the status is changed to red.

Current IF statement:

=IF(Calc1 > 1, "Green", IF(Calc1 < 0.75, "Red", "Yellow"))

I would like for this to be still in place with the addition of an OR statement that will make the status "Red" if someone clicks the flag

Any help would be greatly appreciated

Mike Wilday

=IF(Calc@row > 1, "Green", IF(OR(Calc@row < 0.75, Urgent@row=1), "Red", "Yellow"))

Try this formula. Or statements have to be formulated like above. Each criterion gets separated by a comma within the full set of parentheses for the OR statement. One thing to note with this layout... is that if your Calc = 1 and your Urgent flag is set you won't get Red. You'll get green. To get Red possibility first, reverse the order of the red and green statements like below. The first criteria to pass will always be the one that is selected. The formula checks each statement until one passes and then stops.

=IF(OR(Calc@row < 0.75, Urgent@row=1), "Red", IF(Calc@row > 1, "Green", "Yellow"))

Mike Wilday

=IF(Calc@row > 1, "Green", IF(OR(Calc@row < 0.75, Urgent@row=1), "Red", "Yellow"))

Try this formula. Or statements have to be formulated like above. Each criterion gets separated by a comma within the full set of parentheses for the OR statement. One thing to note with this layout... is that if your Calc = 1 and your Urgent flag is set you won't get Red. You'll get green. To get Red possibility first, reverse the order of the red and green statements like below. The first criteria to pass will always be the one that is selected. The formula checks each statement until one passes and then stops.

=IF(OR(Calc@row < 0.75, Urgent@row=1), "Red", IF(Calc@row > 1, "Green", "Yellow"))

PCC87

Perfect Mike! Thanks for your help!

Mike Wilday

Glad I could help. Please mark my post as best answer if it solved your issue! :)