I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ‚¬ then * by 0.68. That way I could get all of our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is in.

Thanks in advance!