Currency calculation in Excel

Preparations;

• Price in base currency in Column P
• Base currency in Column Q
• Currencies in named cells in separate sheet

Equation;

=IF(Q1=”SEK”;P1*SEK;IF(Q1=”USD”;P1*USD;IF(Q1=”EUR”;P1*EUR;IF(Q1=”GBP”;P1*GBP;”Check the currency!”))))