Hello All,

Many thanks again to SHG for his original help here,,,, and the main formula which was;

Code:

`B6: =IF(ISNUMBER(B2), B2, IF(ISNUMBER(B3), B3 * B1, IF(ISNUMBER(B4), (1 - B4) * B1, "")))`

But now seeing as I've reconfigured my spreadsheet and added cells, moved cells etc I'm totally confused!!

Still trying to figure out how to get this working,,, looking at SHG's original code as a starter, to try and work out the math.

My math always has been, well,, crap!

trying to get my head around this now,, I think I'm about to explode!

The sheet is here if anyone can attempt to get this off the ground and working.

https://www.dropbox.com/s/ejhw951yzkaepjd/Win-Loss-Calculator.xlsx?dl=0
Image on imur

https://imgur.com/a/J2xGYeh
Basically I've now made the calculator into a GAIN or LOSS calculator now,,,using a list select in cell I6

1. So 1st you choose the amount (For example £3000) in Cell I4

2. You select if it was a GAIN or a LOSS from cell I6

3. You then can choose to imput 1 of 3 options;

£ gained or lost (Cell E10),,, % Gained/Lost (cell G10),,, or finally Ending Balance(£'s) (In Cell I10)

So that's what a user can select,,, he/she only has to actually input into 2 cells and 1 selection GAIN or LOSS from cell I6

===============

All the above then leads onto formulas to auto calculate all the cells in in Column I

I14 Calculates times gain or loss,, so (3x) means 3 times gain

I16 £'s gained or lost

I18 % Gained or Lost

I20 Recovery % to break even (if applicable,, if it was a loss)

I23 Amount in £'s to recover to break even

I25 Ending Balance in £'s

This isn't so easy as I originally thought!

Will be a long formula (IF and OR) I think?

Any help here grately appreciated.

It's completely done my head in, a need another Hot mulled cranberry punch seeing as it's still Christmas!

Yours sincerely

John C