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 ?

pdaniels450@hotmail.com.

benny

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

=DOLLAR(A1/4,2)

If that's not what you want then restate your question.

Thanks for your reply jfc

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