If Statement with multiple conditions?
I'm having a moment and figure out how to format this formula. I just need the statement to read, If [state abbreviation]= ("NJ","NY" etc. etc....), 30, If [state abbreviation] = ("MI", etc......
Forum Discussion
You may want to consider using CASE.
Case([state abbreviation],"NJ",30,"NY",30"MI",20)
To use the IF statement, I would do it like this:
If([state abbreviation]="NJ",30,
[state abbreviation]="NY",30,
[state abbreviation]="MI",30
)
Case([state abbreviation],"NJ",30,"NY",30"MI",20)
To use the IF statement, I would do it like this:
If([state abbreviation]="NJ",30,
[state abbreviation]="NY",30,
[state abbreviation]="MI",30
)
Case(
[abbreviation], "HI","ME","MI","MO","MS","NE","NJ","NM","OH","OK","SC","UT","WV", 30,
Case(
[abbreviation], "AZ","CO","FL","GA","IA","ID","IN","MA","MD","MT","NC","ND","OR","VA","WY", 45,
Case(
[abbreviation], "AL","AK","AR","CA","CT","DE","IL","KS","LA","MN","NH","NV","NY","PA","RI","SD","TN","TX","WI", 60,
Case(
[abbreviation] = "KY", 75,""))))
This is what I have but its saying its still not right, any ideas?
[abbreviation], "HI","ME","MI","MO","MS","NE","NJ","NM","OH","OK","SC","UT","WV", 30,
Case(
[abbreviation], "AZ","CO","FL","GA","IA","ID","IN","MA","MD","MT","NC","ND","OR","VA","WY", 45,
Case(
[abbreviation], "AL","AK","AR","CA","CT","DE","IL","KS","LA","MN","NH","NV","NY","PA","RI","SD","TN","TX","WI", 60,
Case(
[abbreviation] = "KY", 75,""))))
This is what I have but its saying its still not right, any ideas?