I feel like this should be quite simple to solve for, however I’m lousy at formulas and looking for someone that could steer me in the right direction please.
What I need the formula to do is convert the value depending on the Country column. The formula should read like the below, but using the correct formatting…
’IF ‘Country’ is ‘United States’ MULTIPLY ‘Value’ by 1.32 AND IF ‘Country’ is ‘Spain’ MULTIPLY ‘Value’ by 1.49
Any help would be appreciated!