Howdy!
I'm trying to figure out how to do an equation in EXCEL - hopefully someone here is good at maths!
This is a financial equation, so the top number represents value and the bottom debt.
Required Percentage = 33%
Value = 100
Debt = 40
Doing the equation... 40/100 = 40%
What I want is for EXCEL to calculate the required "Input" which reduces the debt /value ratio to 33% (adjustable to whatever is required)
Doing it manually...
Input = 10
Value = 90 (100-10)
Debt = 30 (40-10)
30/90 = 33%
So it this instance, I would enter in 33% into a field, EXCEL would look at the current Value and Debt values and calculate the answer is 10.
Anyone?
Regan
I'm trying to figure out how to do an equation in EXCEL - hopefully someone here is good at maths!
This is a financial equation, so the top number represents value and the bottom debt.
Required Percentage = 33%
Value = 100
Debt = 40
Doing the equation... 40/100 = 40%
What I want is for EXCEL to calculate the required "Input" which reduces the debt /value ratio to 33% (adjustable to whatever is required)
Doing it manually...
Input = 10
Value = 90 (100-10)
Debt = 30 (40-10)
30/90 = 33%
So it this instance, I would enter in 33% into a field, EXCEL would look at the current Value and Debt values and calculate the answer is 10.
Anyone?
Regan