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.