Validation List/Formula Question

J

JWNJ

My goal seems to be fairly basic, but I have not been able to figure out an
easy formula. I would appreciate your thoughts/suggestions.

Lets say I have a validation list of the 50 US States in cells A1. In B1 I
want an output based on the state selected in A1. Lets say if A1 = NY or NJ
or MA or FL the output is 1, for all other states the output is 0. I know I
can write a formula such as
=if(a1="NJ",1,if(a1="NY",1,if(a1="MA",1,if(a1="FL",1,0)))). My question is,
can I use some sort of "OR" statement in place of all the IFs?

I need to avoid all of the IFs because this is actually the lead question in
a series of nested if/then questions in a much longer formula.

Thanks in advance for any suggestions.
 

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

Top