O
oldjay
I can't get a result for the following
If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0
If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Per Jessen
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
I think this is the formula you need in A4:
=IF(OR(A1=1,A2=2),IF(A3=3,4,0),0)
Regards
Per
O
oldjay
Doesn't work- If you put a 0 in a1 it still give a result of4
O
oldjay
It's right
oldjay
oldjay
oldjay said:Doesn't work- If you put a 0 in a1 it still give a result of4
B
Brian
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).
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).