I don't know which of my formulae you decided you needed?
My original =A2/((1-10%)*(1-20%)) would have been OK if somebody got 10% of
the original selling price and then somebody else got 20% of what was left
after that 10% deduction (or vice versa).
My later =A2/(1-30%) was when you changed the requirement and said that you
wanted to take "20% of the retail sell price" and "10% of the same retail
sell price".
Make sure that you decide what it is that you really need.
--
David Biddulph

"Derro" wrote in message
...
HOLD THE BOAT!! THANKS DAVID I JUST MANAGED TO APPLY YOUR FORMULA AND IT
IS
JUST WHAT I NEED THANK YOU ALL

"Derro" wrote:

Thank you David Pete & Bill
I was remiss in not being clearer. The formula is to work out a retail
sell
figure for goods that are sold at our community store. Local people
bring
there home made goods in and say "I want X amount per item." Lets for
example say they want a $10 return. What we then have to do is work out
what
figure we need to sell the goods for so that the local hospital get 20%
of
the retail sell price and the organisation who are housing the store get
10%
of the same retail sell price. And of course the local get there $10.
Obviously the figure is going to be larger than the $10 but how do we
arrive
at that figure. After the sale it is easy to work out what the percentage
is
for the two organisations but what's left must equal the $10.
Hope that's clearer and thanks to all
Derro


"David Biddulph" wrote:

=A2/((1-10%)*(1-20%))
--
David Biddulph

"Derro" wrote in message
...
Unfortunatly my old brain is not what it used to be. My problem is
that I
need to make up a simple formular that will allow me to enter
different
amounts in a cell multiple times and get the answer as follows. I
need a
figure that After deducting 10% to one cell and 20% in another cell
the
answer will come back with what I put in the first cell. In other
word a
reverse formular.