Excel Help

[Benny]

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

[bluetown]

Do you have Email ?

[Benny]

pdaniels450@hotmail.com.

benny

[Crackone]

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

[jfc]

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.

[Crackone]

=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

[jfc]

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

[Crackone]

=(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 oddsWhere getting close I would like to put $4 in A1 not the decimal 5.00

[jfc]

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


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

[Crackone]

=DOLLAR((VALUE(A1)-1)/4+1,2)the result is eg $4 in A1 =$1.75 if you put $5 in result is $2

[OZDOC]

the result is eg $4 in A1 =$1.75 if you put $5 in result is $2
Why dont you just format your cells to currency?
then you only need
=(A1-1)/4+1