Excel if functions

Copper Contributor
Can if(or) and if(and) functions be combined into one formula?
1 Reply

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")