if then statement

S

steven

when using an if then statement can you use "and"? for
example, if(a2>=0,if(d7>=a5"and"h8>=a5..........
 
D

Dave Peterson

=if(a2>0,if(and(d7>=a5,h8>a5),....

is one way.
when using an if then statement can you use "and"? for
example, if(a2>=0,if(d7>=a5"and"h8>=a5..........
Click to expand...
 
B

Bernard Liengme

Use =IF(a2>=0,IF(AND(D7>=A5,H8>=A5),....
or =IF(a2>=0,IF(D7>=A5)*(H8>=A5), ...
 
Top