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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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