recovery calculator

Hello Everyone.
I was wondering if anyone can help me please.
I have a spreadsheet that lists a table of recovery from drawdown figures.
I have come up with a calculator which I have formatted but I do not know how to create the formulas to get it working
I attach the spreadsheet here if anyone could help me & would like to look.
http://tinyurl.com/kjurk3

1. Basically you enter the amount of money before drawdown.(Cell O11)
2. Then you can enter either;
£ Lost (Cell I16)
or % Lost (Cell L16)
or % Left (Cell O16)
3. Depending on which one of the above 3 you entered the calculator would automatically
calculate the other 2 cells & return 2 more stats which would be;
4. Recovery % Required (To return to Initial Start Equity (Cell O21)
5. Recovery Amount Required in £ To return to Initial Starting Equity.(Cell O23)

I do hope someone could help me as I am not able to work this out
in excel formula to get the cells producing the correct results.
This really would be most useful.
I thank you all for your time.
I really hope someone can help me with this.
Many Thanks again
TheGhost

Hi Mrjinx007!!
Many thanks for your reply.
Your formula for the % left,, I think it needs to be;

Please Login or Register  to view this content.

Because there is £2000 left from the £3,000 starting stake.
Your formula is taking into account only the £1000 lost
Yep, I think that's it?

Also recovery % required;(Cell O21)
If you started with £3,000 & you lose £1,000, so you now have £2,000 left.
So,, you now need a 50% increase to get back to £3,000 (IE 50% of £2,000 is £1,000)
£2,000 you have now + the £1,000 gets you back to the £3,000 starting amount.
I've got this formula now as;

Please Login or Register  to view this content.

So also the recovery in £'s has to equate to £2,000,, so formula would be I think;

Please Login or Register  to view this content.

Yes, that's it I think.

So, now it's working (Kind of) ,,, but ONLY if someone enters data in cell I16 (The £ lost Cell)
What I really would love this calc to be able to do is function when only 1 of the 3 yellow cells has data inserted. (The 3 yellow cells being either £ Lost, or % lost or % left).

I've thought of a way to do this ,,, IE for the formulas to be in cells hidden 1 row below the 3 yellow cells.
that way, the yellow cells don't need formulas in,, they are just a user input field.
I'll link to an example sheet so this is all making sense; with all the formulas in as it stands now
Calc-download

I've changed the table formula cells in the sheet with the above link, but that's how the calc stands now.
So,, the formulas would be a bit more complicated,,
As they will work if just 1 of the 3 yellow fields has a user input inserted.
This is where I'm stumped.
Must be some kind of IF/OR formulas.
I'm really not too great in formulas in excel (Or anything else to be honest)
It's above me.
If anybody has any idea how this can be achieved I'm all ears.
Again,
Many thanks for your reply
Always greatly appreciated
I really hope somebody can crack this, it's above me
Regards
TheGhost