Nested IF, AND, OR

[smg]

Hi Guys,

I have inserted the following formula into Z3 cell:

=IF(AND(ISNA(V3),ISNA(W3)),"NA",IF(OR(TRIM((U3)*1)=TRIM((V3)*1),TRIM((U3)*1)=TRIM((W3)*1)),"OK","ERROR"))

The purpose of this formula is to compare values between U3 and V3 and U3 and W3. Usually V and W are mutually exclusive, so if one contain the value, the other one will not ("N/A"). That's why I need the first check for - to check whether two of them are "N/A". If at least one contain the value then I want to compare this value with U and then return one of the following arguments "OK", or "ERROR". The problem is that even when one V or W contains the value, it returns "#N/A", that is the value that I want to avoid.

Can anybody help me with that please? I've checked the formula a few times and it seems correct.

Cheers,
Slawek

 

[smg]

OK, resolved. I used the following, simpler formula:


=IF(ISNA(V3),IF(W3=U3*1,"OK","ERROR"),IF(V3=U3*1,"OK","ERROR"))


"1" is just to convert a text to a number.

Thanks anyway for viewing this post.


S