Hello!
I built a calculator in Excel 2010. It works perfectly until I had to add an additional input to be used as a percentage of down payment instead of the essential input which is amount of down payment.
Successfully do that, I can use either one and both have to update each other.
This is because sometimes I need to input a percentage and straightforward know the amount rather than estimate the percentage based on multiple tries of input the amount.

Is there a function,trick or workaround to let that happen and let Excel continue calculation of rates and rest of outputs?

Thank you for assistance,