| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I use the argument: - IF, AND, THEN, ElSE
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Can I use the argument: - IF, AND, THEN, ElSE
=if(and(a1<=0,b1<5),0,A1*b1)
Newie wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the argument funcation | Excel Worksheet Functions | |||
| what is an argument? | Excel Discussion (Misc queries) | |||
| if argument? | Excel Discussion (Misc queries) | |||
| One more Argument. | Excel Worksheet Functions | |||
| IF THEN argument | Excel Discussion (Misc queries) | |||
Linear Mode
