Can I use the argument: - IF, AND, THEN, ElSE

N

Newie

I have created a formula using IF,THEN,ELSE but, I now find that my IF
argument needs to refer to two cells.
i.e.
=if(a1<=0,(and)b1<5,0,A1*b1)

Can anyone advise how this can be done
 
D

Dave Peterson

=if(and(a1<=0,b1<5),0,A1*b1)

I have created a formula using IF,THEN,ELSE but, I now find that my IF
argument needs to refer to two cells.
i.e.
=if(a1<=0,(and)b1<5,0,A1*b1)

Can anyone advise how this can be done
Click to expand...
 
Top