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

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

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

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