Thread: "If" statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confused Confused is offline
external usenet poster
 
Posts: 1
Default "If" statement

I have three columns:

State NCA or SCA Zip code
CA NCA 93601
NY NAP 11375
CA SCA 93550

I am trying to write a formula where, if State equals to CA, then evaluate
Zip Code, where if Zip Code is greater than 93600, return NCA, or if zip code
is less than 93600, return SCA, if State does note equal to CA, return NAP.

Can someone please help me?