Solver question

[regan]

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

[Jazzer]

Hi,

I think this is much easier to solve with simple algebra, rather that with Excel's solver. If you write this as a formula and solve out the input value, you'll get

Input = (Debt - percentage * Value) / (1 - percentage)

and percentage <> 100 %

Hope this helps.

- Asser

[TonyS]

Hi,
Try this.
Tony