View Full Version : Excel Help

Benny

19th August 2006, 06:05 PM

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

19th August 2006, 09:01 PM

Do you have Email ?

Benny

20th August 2006, 03:35 PM

pdaniels450@hotmail.com.

benny

Crackone

27th August 2006, 11:28 AM

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

27th August 2006, 11:44 AM

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

27th August 2006, 12:03 PM

=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

27th August 2006, 12:21 PM

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

27th August 2006, 12:47 PM

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

27th August 2006, 12:59 PM

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

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

Crackone

27th August 2006, 01:35 PM

=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

27th August 2006, 08:43 PM

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

vBulletin v3.0.3, Copyright ©2000-2024, Jelsoft Enterprises Ltd.