Excel Questions and Help

Question

1. I want to connect the CHECKBOX with the Amount and it will automatically subtracted with the remaining balance once I clicked the CHECKBOX. Please help me with this formula.
2. I want to connect the CURRENCY DROP DOWN with ALL THE AMOUNT, PRINCIPAL AMOUNT, MONTHLY PAYMENT AND REMAINING BALANCE. Once they choose the currency it will automatically change.

Please help me finishing this the letters and numbers are there already, I need a step by step please

Answer 1

Could you share a test file? It will help to save time to recreate your scenario. Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.

Based on your description, you want all the value to be changed when you change the currency.

In a separate sheet or a range of cells, list all the currencies and their conversion rates. Then it can be used in formula.

Answer 2

Hello please help me

https://docs.google.com/spreadsheets/d/1Ibp46wuZRaJiKPBXeu5Cp35lxltveFnY/edit?usp=sharing&ouid=117509943496967336310&rtpof=true&sd=true

additionally,

I want to connect the CHECKBOX with the Amount and it will automatically subtracted with the remaining balance once I clicked the CHECKBOX. Please help me with this formula. It automatically subtracting whenever I thick the CHECKBOX , thank you!

Answer 3

Hi,

In range F20:F42, insert check boxes (from the insert menu). Check any box and your formula in cell E13 will show the correct result.

Hope this helps.