Hi there,
I am trying to derive the Insurance Premium for policies where premium is in different currencies. This is in sheet1 which has currency symbol and their corresponding premium. I have a Rate of exchange tab (sheet 2) that converts all currencies into either GBP or USD.
I am trying to converts all premium from different currencies into 1. GBP and 2. USD. not sure which formula will help me complete this. any help is greatly appreciated.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am trying to derive the Insurance Premium for policies where premium is in different currencies. This is in sheet1 which has currency symbol and their corresponding premium. I have a Rate of exchange tab (sheet 2) that converts all currencies into either GBP or USD.
I am trying to converts all premium from different currencies into 1. GBP and 2. USD. not sure which formula will help me complete this. any help is greatly appreciated.
Currency | Original Prm | USD Amount | Sterling Prm |
GBP | 51424.37 | ||
USD | -20000 | ||
EUR | 1219.24 | ||
IND | 5803.57 | ||
RUB | -670 | ||
BSD | -24700 | ||
BWP | 11000 | ||
CAD | 342.5 | ||
CDF | 10510 | ||
CHF | 4500 | ||
CLF | 229500 | ||
CLP | 9000 | ||
CNH | 11000 | ||
CNY | 803.19 | ||
COP | 3750 | ||
GBP | 900 | ||
USD | -235261.13 | ||
EUR | 19035 | ||
IND | 22800 | ||
RUB | 1037531.25 | ||
GBP | -556.03 | ||
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>