"If" statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Assuming columns A, B and C in use, and that entries for state abbreviations
start in row 2, put this in B2:
=IF(A2="CA",IF(C2>93600,"NCA","SCA"),"NAP")
fill down the sheet
If your zip codes are text, to preserve leading zeros, also enclose the
93600 within double quotes as:
=IF(A2="CA",IF(C2>"93600","NCA","SCA"),"NAP")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated If, AND, OR - Conflict 8
= If (in list) 1
How write criteria in expression to search a range and return valu 2
Query using dlookup 1
Dlookup Using Expression Builder 4
Anyone who can help my fried mind with this solution? 1
Parsing Address, City ST ZIP 7
Excel Excel count rows and add equal rows when matched 0

Back
Top