Gossamer Forum
Home : General : Chit Chat :

Mathematical Question - anyone good with maths!?

Quote Reply
Mathematical Question - anyone good with maths!?
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

Last edited by:

ryel01: Nov 1, 2007, 11:04 PM
Quote Reply
Re: [ryel01] Mathematical Question - anyone good with maths!? In reply to
Hi,

((p * v) - (100 * d)) / (p - 100) = answer

where p is percentage, v is value and d is debt.


Merten