Multiple Currencies

Hi guys,

I'm apologizing in advance if this has been posted. Thing is, I'm in the office and don't have time to browse.

I am trying to create our company's sales report. Supplier costs vary from USD, EUR, GBP and AED. I need all prices in AED. What formula should I use so that if I populate the USD cell (leaving EUR and GBP blank), AED column will automatically convert it from USD to AED? Same as if I populate EUR, AED column will automatically convert from EUR to AED. I wouldn't wanna do the manual formula (=F10*3.675) or (=G11*4.9).

Thank you so very much.

Hi,

I copied the formula in I10 but this warning comes up:

Warning.png

And when I press ok, the value in I10 is zero.

Hi Nikamorphoses,

Based on the assumption that you enter in the quantities supplied in Col E and the "invoice" values from your suppliers in Cols F,J K and L (depending on the suppliers currency), then the attached should work.

Regards

peterrc