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
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)
