compare cells

[Muthukrishnan V]

Excel 2003 - A formula in "Sheet3 J6" which should compare the numerical
value in "Sheet1 C116", "Sheet2 E60" and "Sheet3 D82" are same. I mean, if all the three values are same, return say, "true" and if ALL the three are NOT same return "false". Request help.

 

[schielrn]

Try:

=AND(Sheet3!J6=Sheet1!C116,Sheet3!J6=Sheet2!E60,Sheet3!J6=Sheet3!D82)

Hope that helps.

 

[dave3009]

Try this also, you need to adjust your ranges to suit

=IF(AND(H3=I3,H3=J3,H3=J3),TRUE,IF(AND(H3<>I3,H3<>J3,H3<>J3),FALSE,"Matching"))

KR


Dave

 

[Muthukrishnan V]

Still not able to achieve the result. Cell J6 returns "0" when all the three cells are either same or different.

 

[schielrn]

If you are trying to use the formula I gave you in J6 of sheet3 then you will get 0 because that is a circular reference as one of the cells you are comparing is J6?

Not sure what exactly you are trying to do because you cannot check a cell for a value within that same cell?