I am not sure if I understand you correctly. You mean i would make a table with expected exchange rate of the currencies (that seems rather odd)? Or do you mean i enter the rate which i wil assume to be valid for a certain period of time?

I would also be satisfied if i could google the current exchange rate , put that data in a cell manually so that excel can calculate the new prices in the new currency (and add the fitting symbol ofcourse).