Currency Conversion

[rathnam_qv]

Hi All,

i have a straight table in that i have some values in Dollars.

My requirement is...i want to create two Radio button on the sheet USD and INR. when i clik on INR the Dollar values should convert as INR and Vice versa

can any one help me.

regards,

rathnam

[datanibbler]

Hi rathnam.qv,

I cannot help you myself, I can just give you a few hints:

- There is a thread around here about conversion_rates from a website called oanda.com - alongside many others - I haven't yet tested it, but
   it should be possible.

- Me instead, I use a "fixed" conversion rate that is used for a certain period throughout the company to ensure consistency - that comes via email and I have an Excel file with four columns

     - valid_from_date

     - valid_to_date

     - rate_$_to_€

     - rate_€_to_$

=> Then I use the Intervalmatch() function (with a date_field in my data_table) to draw the correct rate for a certain date (that is thereby matched with the periods formed by the valid_from and valid_to in my Excel)

HTH

Best regards,

DataNibbler

[#3]

One possible approach in attachment.

Hope it helps

Darek