if then statement

steven · Jun 26, 2004

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

Dave Peterson · Jun 26, 2004

=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..........

Bernard Liengme · Jun 26, 2004

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