Excel 2002: Can I compare 4 cells at one time ?

[Mr. Low]

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

 

[FSt1]

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

regards
FSt1

 

[Niek Otten]

Hi Low,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[David Biddulph]

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

 

[Bob Flanagan]

=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]

Dear Sir,

Thanks for the formula.

Low

 

[Mr. Low]

Hello Neik,

Thanks for the formula.

Low

 

[Mr. Low]

Hello Bob,

Thanks for the formula.

Low

 

[Mr. Low]

Hello David,

Thanks for the formula.

Low