Replacing two values in the same formula
What would be the syntax to using a single formula to replace 2 different values? Right now I'm using the formula below that works for a single state, but also trying to replace Penn. with Pennsylvania in the same formula.
Hi John Finnerty - Welcome to the community. We're glad to have you here!
I would lean towards writing multiple conditions using a CASE statement:
Community.Sheet1.Abbrv = 'Oh','Ohio',
Community.Sheet1.Abbrv = 'Mich','Michigan',
Community.Sheet1.Abbrv = 'Penn','Pennsylvania',
Community.Sheet1.Abbrv = 'Ore','Oregon',