Exchange rate calculation

H

hkeroh

I'm fairly new to Excel:

Does anyone know how to calculate the exchange rate for two given
currencies in Excel? I have the two currencies in my spreadsheet but
I'm supposed to create a formula that shows the exchange rate between
the two currencies.

Also, where can I find the Future Value function in Excel?

Thanks for your help in advance!
 
P

PeterAtherton

hkeroh

Homework?
A
Pounds 0.708064859
Euro 1.4123

Convert £ 100

Euros 141.23

Where you calculate the number of Euros with =100*1.14123 or by the cell
references of those amounts. if the Euro rate is in B2 and the amount in b4
the euros is =B2*B4

To find the FV value double-click the fx symbol on the edit line; this opens
the function dialog box, in the search for box type future value and press go
- you might like to select the financial category in the drop down box.

Regards
Peter
 
Top