| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I compare 4 cells at one time ?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
=IF(AND(A1=B1,B1=C1,C1=D1),"OK","Error")
-- David Biddulph "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
=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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
Dear Sir,
Thanks for the formula. Low -- A36B58K641 "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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
Hello Neik,
Thanks for the formula. Low -- A36B58K641 "Niek Otten" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
Hello Bob,
Thanks for the formula. Low -- A36B58K641 "Bob Flanagan" wrote: =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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Can I compare 4 cells at one time ?
Hello David,
Thanks for the formula. Low -- A36B58K641 "David Biddulph" wrote: =IF(AND(A1=B1,B1=C1,C1=D1),"OK","Error") -- David Biddulph "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : How to eliminate the time value after the date ? | Excel Discussion (Misc queries) | |||
| Is arithmetic on time data possible in Excel 2002? | Excel Discussion (Misc queries) | |||
| time v cost calculation in Excel 2002 (XP) | Excel Discussion (Misc queries) | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| How can I add up time, say 18:00 + 18:00 hrs in excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
