| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IFOR<ABD
I can't get a result for the following
If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IFOR<ABD
Hi
I think this is the formula you need in A4: =IF(OR(A1=1,A2=2),IF(A3=3,4,0),0) Regards Per "oldjay" wrote: I can't get a result for the following If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IFOR<ABD
Doesn't work- If you put a 0 in a1 it still give a result of4
"Per Jessen" wrote: Hi I think this is the formula you need in A4: =IF(OR(A1=1,A2=2),IF(A3=3,4,0),0) Regards Per "oldjay" wrote: I can't get a result for the following If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IFOR<ABD
It's right
oldjay "oldjay" wrote: Doesn't work- If you put a 0 in a1 it still give a result of4 "Per Jessen" wrote: Hi I think this is the formula you need in A4: =IF(OR(A1=1,A2=2),IF(A3=3,4,0),0) Regards Per "oldjay" wrote: I can't get a result for the following If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IFOR<ABD
That formula is like:
if (a1=1 or a2=2) and (a3=3) then a4=4 otherwise a4=0 But the original post could just as well be interpreted as: if a1=1 or (a2=2 and a3=3) then a4=4 otherwise a4=0 As an example, if a1=1, a2=2 and a3=0, these two interpretations give different results (the first gives a4=0 and the second gives a4=4). "Per Jessen" wrote: Hi I think this is the formula you need in A4: =IF(OR(A1=1,A2=2),IF(A3=3,4,0),0) Regards Per "oldjay" wrote: I can't get a result for the following If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
