|
| Re: QPro V8: Can I compare 4 cells at the same time ? |
 |
Fri, 07 Mar 2008 07:28:55 -060 |
If you ask qp8 questions then please post to the
QuattroPro_older_versions group.
@IF(A1=B1#AND#B1=C1#AND#C1=D1,"OK","Error")
|
| Post Reply
|
| QPro V8: Can I compare 4 cells at the same time ? |
 |
Fri, 7 Mar 2008 20:53:51 +0800 |
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
May I know what formula must I input at cell E1 and copy down to get the
answer?
Thanks
Low
|
| Post Reply
|
|
|
|
|
|
|
|
|
|