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
|