Thread: Can I use the argument: - IF, AND, THEN, ElSE
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Can I use the argument: - IF, AND, THEN, ElSE
You could have looked in the HELP index for AND

--
Don Guillett
SalesAid Software

"Newie" wrote in message
...
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 With QuoteReply With Quote