To convert Foreign Currencies to USD, FOREXtoUSD as a VBA fnction can be used.

The function gets the currency and the exchange rate from the main excel sheet and does the conversion for us.

In the main page, by using the formula FOREXtoUSD(B13,A13) for C13 cell, we have