hi
try something like this....
=IF(AND(A1=B1,B1=C1,C1=D1),"OK","Error")

regards
FSt1

"Mr. Low" wrote:

Dear Sir,

If I want column E to return with "OK" when cells at each row has identical
entry from column A to D, otherwise return with "Error".


A B C D E
1 K21 K21 K21 K21 OK
2 RQ1 RQ1 RX3 RQ1 Error
3 H6U K8Y K8Y H6U Error

What formula must I input at cell E1 and copy down to get the answer?


Thanks

Low

--
A36B58K641