Sep 13 2021 12:10 PM
Sep 13 2021 12:39 PM - edited Sep 13 2021 12:41 PM
Considering a simple test to chek if A2 and/Or B2 are greater than 2.
=IF(OR(A2>2,B2>2),"Some values are greater than 2","Values are NOT Greater than 2")
=IF(AND(A2>2,B2>2),"Both Values are greater than 2","Anything")
=IF(OR(A2>2,B2>2),"Some values are greater than 2","Values are NOT Greater than 2")
=IF(AND(A2>2,B2>2),"Both Values are greater than 2","Anything")