Compare cells

[Muthukrishnan V]

Excel 2007

I want Sheet 4, column E5 to return “OK”, if Sheet1 C20, Sheet1 K50, Sheet2 E 70 and Sheet3 J11 are all of same value. If all the 4 values are not same, then return “Not OK”. (May be text or numerical)

 

[tyija1995]

Hey, put this in E5 on sheet 4:

=IF(AND(Sheet1!C20=Sheet1!K50,Sheet1!C20=Sheet2!E70,Sheet1!C20=Sheet3!J11),"OK","Not OK")

 

[Muthukrishnan V]

Thank you Sir