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 ?

pdaniels450@hotmail.com.

benny

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

=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

=(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

Where getting close I would like to put $4 in A1 not the decimal 5.00

=DOLLAR((VALUE(A1)-1)/4+1,2)

the result is eg $4 in A1 =$1.75 if you put $5 in result is $2