| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF HELP
Hi, I have the an spreadsheet with 4 columns I want to to put in column 5
'ALL OK" only if all 4 reads OK on all of them the rest will read INCORRECT Address City State Zip OK OK OK OK Wrong address Wrong city OK Wrong Zip Wrong address OK OK OK #N/A #N/A #N/A #N/A Wrong address OK OK OK OK OK OK OK Wrong address OK OK OK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF HELP
=IF(COUNTIF(A2:D2,"OK")=4,"OK","INCORRECT")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Compare Values" wrote in message ... Hi, I have the an spreadsheet with 4 columns I want to to put in column 5 'ALL OK" only if all 4 reads OK on all of them the rest will read INCORRECT Address City State Zip OK OK OK OK Wrong address Wrong city OK Wrong Zip Wrong address OK OK OK #N/A #N/A #N/A #N/A Wrong address OK OK OK OK OK OK OK Wrong address OK OK OK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF HELP
Thank you so much for your help Bob. but I don't the columns in sequence I
have them on A, C, F, G. Can you please advise how should I write the formula. "Bob Phillips" wrote: =IF(COUNTIF(A2:D2,"OK")=4,"OK","INCORRECT") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Compare Values" wrote in message ... Hi, I have the an spreadsheet with 4 columns I want to to put in column 5 'ALL OK" only if all 4 reads OK on all of them the rest will read INCORRECT Address City State Zip OK OK OK OK Wrong address Wrong city OK Wrong Zip Wrong address OK OK OK #N/A #N/A #N/A #N/A Wrong address OK OK OK OK OK OK OK Wrong address OK OK OK |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF HELP
Hi
One way =IF((A2="OK")*(C2="OK")*(F2="OK")*(G2="OK"),"OK"," WRONG") -- Regards Roger Govier "Compare Values" wrote in message ... Thank you so much for your help Bob. but I don't the columns in sequence I have them on A, C, F, G. Can you please advise how should I write the formula. "Bob Phillips" wrote: =IF(COUNTIF(A2:D2,"OK")=4,"OK","INCORRECT") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Compare Values" wrote in message ... Hi, I have the an spreadsheet with 4 columns I want to to put in column 5 'ALL OK" only if all 4 reads OK on all of them the rest will read INCORRECT Address City State Zip OK OK OK OK Wrong address Wrong city OK Wrong Zip Wrong address OK OK OK #N/A #N/A #N/A #N/A Wrong address OK OK OK OK OK OK OK Wrong address OK OK OK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
