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...