Thread: IF HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Compare Values Compare Values is offline
external usenet poster
 
Posts: 17
Default 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