if problem again...

[Juunis]

What I try to do:
if E4=J4 AND F4=K4, result 5 (if not, the result should be 0)
if else E4=J4, result 2
if else F4=K4, result 2
else, result 0

The first row goes like this:
=IF(AND(E4=J4,F4=K4),5,0)

But if I try to add the second row IF(E4=J4,2,0), there comes some
complains about "too many arguments"..
IF(AND(E4=J4,F4=K4),5,0, IF(E4=J4,2,0)) //This doesn't work!
Any ideas, how to solve?

- jp

 

[Govind]

Hi Juunis,

Try

=IF(AND(E4=J4,F4=K4),5,IF(OR(E4=J4,F4=K4),2,0))

Regards

Govind.

 

[Juunis]

Hi Juunis,

Try

=IF(AND(E4=J4,F4=K4),5,IF(OR(E4=J4,F4=K4),2,0))

Regards

Govind.

Thank you, works perfectly!!

Br, JP