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

[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

 

[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

 

[Don Guillett]

You could have looked in the HELP index for AND