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
Another simple choice is to make a table of State Abbreviations, and makea Relationship back to the detail records. Then pull in the numerical values on a lookup.