Varied Multiplier based on cell text

[marzwrob]

I have a table like follows. I need to do something like the following:

• if country = GB then: SUM(grossTotal)*1.16
• if country = CH then: SUM(grossTotal)*0.0023

There are several conditions like such.

How can I best do this? e.g. is it better to create a lookup table and link, or can I have some IF statement which would cover this?

[ChiragGarg2512 · Accepted solution]

Instead of IF, use of SWITCH statement will be better in this case. But the use of either switch or if will result in writing a lot of statements.   
The best would be to create a lookup table for country and the currency multiplier for that country.