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!”))))
Wordpress theme design by Anders Noren — Up ↑