=if(and(a1=b1, a1=c1, a1=d1, a1=d1),"ok","error")

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for 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