ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   valuta (https://www.excelbanter.com/excel-programming/294793-valuta.html)

Rambo[_2_]

valuta
 
what is the formula for tranlate dollars or ponds in euro`s?

sorry for the tekst



Frank Kabel

valuta
 
Hi
you have to get the exchange rate into one field
e.g. A1 stores 1.20 (that is 1EUR = 1.20$)
if B1 stores your dollar value use the following formula in C1
=B1*(1/A1)

--
Regards
Frank Kabel
Frankfurt, Germany


Rambo wrote:
what is the formula for tranlate dollars or ponds in euro`s?

sorry for the tekst



All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com