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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newie - 14 Jun 2007 03:52 GMT

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

Reply to this Message

Dave Peterson - 14 Jun 2007 03:57 GMT

=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

Signature

Dave Peterson

Reply to this Message

Don Guillett - 14 Jun 2007 13:49 GMT

You could have looked in the HELP index for AND

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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

Reply to this Message