check multiple conditions, several IF statements

[dorado]

Hi guys,

I need help for placing IF statements, ie have a scenario when two conditions are true, one of them, or neither of them. Simple example:

In cell A1 have number 14
In cell B1 have number 7

Numbers in cells are not fixed, can be chanced

Want to check whether A1 is greater than 5 and B1 are greater than -7. Have four scenarios

1. if both are TRUE then type "Yes"
2 if only A1 is TRUE then "A1 is greater"
3 if only B1 is TRUE then "B1 is greater"
4 if both are FALSE, then type "No"

thanks in advance

Regards,

 

[oldbrewer]

=if(and(a1=14,b1=7),"yes",if(and(a1=14,b1<>7),"A1 is greater",if(and(a1<>14,b1=7),"B1 is greater","no")))

but if say a1 was 3 and b1 was 4 "a1 is greater" would not be true

 

[dorado]

want to check every time i put values in A1 and B1 four possible scenarios, because they are not fixed, gave this numbers just for example

 

[oldbrewer]

Want to check whether A1 is greater than 5 and B1 are greater than -7. Have four scenarios
=if(and(a1 > 5,b1 > -7),"both",if(and(a1 > 5,b1 < 7),"A1 is greater than 5",if(and(a1 < =5,b1 > -7),"B1 is greater than -7","no")))