Adding Multiple Currencies

Hi

I have one column which has 3 types of currencies. Euro, £ and $.

I want to total the 3 but if i do that it will be pretty useless as the total will not lead to any useful information. (due to the simple addition of the 3 currencies)

However is there a method of adding the 3 different euros and converting them at the same time to give me a total amount in £(pound).

So if there were any euro amounts to be added then they would be converted to £ and then summed up ( same being applied to the $ amounts)

Has anyone done this before? Help would be greatly appreciated

Hi,

Easiest way would be to have an extra column to have GBP conversion and then total that.

Ed

Originally Posted by EdMac

Hi,

Easiest way would be to have an extra column to have GBP conversion and then total that.

Ed

Thanks for the prompt reply. I will do that.