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