Previous Topic Next Topic

Comparing cells in excel

Closed
Raj - Feb 28, 2011 at 11:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 03:38 PM
Hello,

I am working on a formula in excel. I want to compare values on 4 different cells and return a value. When the values on columns A, B, C & D are the exactly the same, the formula cell (E) should reflect "Pass". Even if one of the value doesn't match, then it should say "Fail". When there are no values in either of A, B, C & D, then E, the formula cell should be blank.

Appreciate your help. Thanks a ton in advance.

Raj
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 28, 2011 at 03:38 PM
=IF(OR(A1="",B1="",C1="",D1=""),"",IF(AND(A1=B1,B1=C1,C1=D1),"PASS","FAIL"))
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses