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"))

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

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

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

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

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

Hello,

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

1 response