Hi, hopefully someone can help, am not all that mathematically minded!!
If I have the following
Divide them I get
I need to attain a result of 1.25. How can I calculate the minimum amount to subtract off both to attain this result. If I take 1 off the numerator I must take 1 off the denominator, if 2 off the numerator then 2 off the denominator and so on.
Any help greatly appreciated, are there excel functions to these effect? add ins?
. I used fractions for the fun of it.
You say you have to subtract the same amount from both the top and the bottom until the quotient equals the value above.
To determine this number we give it a letter to make it easier to find. In this case it's x. x is defined as the value that will make the above part correct. As it has to be the same both values must be x so we have an equation in x and only x.
Therefore we can solve like any fraction to find x