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

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

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

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

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