Hi everyone. I'm a new so sorry if this is an easy question. I have sales report where I have a State and Country column. If the State column says PR or VI I need the Country column to say Puerto Rico or Virgin Islands instead of showing what it currently shows which is USA.
I entered the formula = If (<Account Bill-to State><>"PR") Then <Account Bill-to Country Name>Else "PUERTO RICO" which give me Puerto Rico but I can't figure out how to get in the part for the VI.
Any ideas ?
I entered the formula = If (<Account Bill-to State><>"PR") Then <Account Bill-to Country Name>Else "PUERTO RICO" which give me Puerto Rico but I can't figure out how to get in the part for the VI.
Any ideas ?