Currency convert

[#1]

i have a table with field currency. it represent the currency in crore, i have buttons in my sheet like LAKES, AND THOUSANDS

IF i click on lakes the crore data will convert into lakes and similar the same how can i do this.

Please help me

[tresesco]

Create a variable say vRate. On click of button 'lakhs', set this variable value to 100, on click of 'thousand' button set it's value to 10000. Now if you write your expression like: =Sum(YourCroreValue)*$(vRate) , you get your desired output on button click. Sample attached.

[#3]

it is converted , but when i click on other button it is not changing the values

[tresesco · Accepted solution]

Check my attached sample

[#5]

Thanks for you help