Compare column with nested if
 

Hi,
I have the results I want with my formula, but would like to know if maybe
it could be done in another way. The situation is as follows.
I am comparing 3 columns in which all 3 data must match. The moment one of
the data does not match I want a message that tells me so, otherwise OK.
My data is in column C, D and E.
My formula is: =IF(C3=D3,IF(D3=E3,IF(C3=E3,"OK","C is not equal to E"),"D is
not equal to E"),"C is not equal to D")
Appreciate your valuable feedback.
Thanks & Regards, Lupe

Compare column with nested if
 

You don't need to test for C3=E3, because you wouldn't have got there unless
C3=D3 and D3=E3.
--
David Biddulph

"Lupe" wrote in message
...
Hi,
I have the results I want with my formula, but would like to know if maybe
it could be done in another way. The situation is as follows.
I am comparing 3 columns in which all 3 data must match. The moment one of
the data does not match I want a message that tells me so, otherwise OK.
My data is in column C, D and E.
My formula is: =IF(C3=D3,IF(D3=E3,IF(C3=E3,"OK","C is not equal to E"),"D
is
not equal to E"),"C is not equal to D")
Appreciate your valuable feedback.
Thanks & Regards, Lupe