Previous Topic Next Topic

Comparing cells in excel

Closed
Raj - 28 Feb 2011 à 11:23
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Feb 2011 à 15:38
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Feb 2011 à 15:38
=IF(OR(A1="",B1="",C1="",D1=""),"",IF(AND(A1=B1,B1=C1,C1=D1),"PASS","FAIL"))

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

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

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses