ExcelBanter - "If" statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - "If" statement (https://www.excelbanter.com/excel-discussion-misc-queries/110336-if-statement.html)

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(C293600,"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")

"Confused" wrote:

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?