![]() |
Excel Help
I have written the following formula to help in calulating my bets based on 2% of my bank.
Headings race no., tab no., opening bank, next bet, return, Profit/loss, running balance =a3*2% I'm trying. Can someone please help? benny |
Do you have Email ?
|
|
fixed odds to place div
Need a formula
How do I get exel to show the place odds from a fixed price e.g $3.70 I now the odds are 1/4 (0.93) but how do I display that figure in $$ terms cheers |
Quote:
=DOLLAR(A1/4,2) If that's not what you want then restate your question. |
Quote:
What I am looking for is the place price that it will pay for a place eg $1.34 with this formula and all the ones I came up with return $0.93 cheers |
Quote:
=(A1-1)/4+1 with this 5.00 decimal odds in A1 gives 2.00 Place which is correct. 3.70 => 1.675 suggesting your $1.34 is wrong for 1/4 odds |
Quote:
|
Quote:
=DOLLAR((VALUE(A1)-1)/4+1,2) |
Quote:
|
All times are GMT +10. The time now is 11:51 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.