Compare column with nested if

[Lupe]

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

 

[David Biddulph]

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