IF statement with a OR statement
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
Help Article Resources
Check out the Formula Handbook template!