mercredi 28 octobre 2015

Lookup of multiple cell to calculate amount from multiple cells

I am trying to find a formula for below

I have a premium amount which is any number these premium amount are in different currencies I have a Rate of Exchange tab that converts all currencies to all currencies. e.g: USD to GBP or EUR to USD or GBP to EUR

Now I want to convert every premium into 1. USD and 2 GBP. any help will be greatly appreciated.

Actual Excel spreadhseet

Aucun commentaire:

Enregistrer un commentaire