IF HELP

[Guest]

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

 

[Bob Phillips]

=IF(COUNTIF(A22,"OK")=4,"OK","INCORRECT")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

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.

 

[Roger Govier]

Hi

One way
=IF((A2="OK")*(C2="OK")*(F2="OK")*(G2="OK"),"OK","WRONG")