Hi Low,

=IF(AND(A1=B1,B1=C1,C1=D1),"OK","Error")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mr. Low" wrote in message ...
| 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