| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
| Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
| compare the first column and concatenate the second column | Excel Worksheet Functions | |||
| How Do I created a nested sumif - if this column has this and thi. | Excel Worksheet Functions | |||
Linear Mode
