I have 3 columns. The worksheet checks if column C is >130 AND if one of the 2 conditions are met... if column A is > than 370 OR column B is >250.
In other words column C has to be true first, then it checks if column A OR B are true. If so, it returns "show", if not, it returns "hide"
I was using IF(and(or(A>370,B>250),C>130),"show","hide")
Question: How can I change this to check If column A>370 OR column B>250 OR column C>130 OR column D>130.
In other words any of the 4 conditions met will return the word "show", otherwise return "hide"?
Bookmarks