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
)
You didn't follow the format. You only use the function Case once. You call the function, state the field then value testing for and value to return.
I only used three in the example but Case, then (, then the field then the state and then the value for that state then the next state and then the value for that state and son on until you list all the states and values for each. You ;ist a vaule for each state, not a bunch of states and one valu for all combined.
Case([state abbreviation],"NJ",30,"NY",30"MI",20)
I only used three in the example but Case, then (, then the field then the state and then the value for that state then the next state and then the value for that state and son on until you list all the states and values for each. You ;ist a vaule for each state, not a bunch of states and one valu for all combined.
Case([state abbreviation],"NJ",30,"NY",30"MI",20)