View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JWNJ JWNJ is offline
external usenet poster
 
Posts: 15
Default Validation List/Formula Question

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.