Excel Formula Help

[jackster109]

Hi all

I have this formula which I use for the Golden Lays

=IF(L10="W",(-J10*H10)+H10,IF(L10="L",H10-(H10*I10),0))

This gives me my returns including betfair's commisions to all the golden lays that I do.

What would be the formula if I was to use it for backing horses on betfair. I would like it to return my profit including the commision if ti won and my liability if it lost.

My stake is "H10", commision rate "I10", and odds is "J10".

Thanks

[mathare]

Hi all

I have this formula which I use for the Golden Lays

=IF(L10="W",(-J10*H10)+H10,IF(L10="L",H10-(H10*I10),0))

This gives me my returns including betfair's commisions to all the golden lays that I do.

What would be the formula if I was to use it for backing horses on betfair. I would like it to return my profit including the commision if ti won and my liability if it lost.

My stake is "H10", commision rate "I10", and odds is "J10".

Thanks=IF(L10="W",((J10-1)*H10*(1-I10)),IF(L10="L",-H10,0))
I think. If it wins your profit is (odds-1)*stake*(1-commission). If it loses you lose your stake.

That assumes your commission is entered as either percentage format in Excel cell formatting or as 0.05, for example. If you've entered it as 5 then take it away from 100 rather than 1

[jackster109]

mathare that works perfect :thumbs

cheers

jackster