Betting Odds how to set that up with a Formula in EXCEL

[RudeBoy]

Betting Odds how to set that up with a Formula in EXCEL - If I bet 100 Dollars at 7/1 Odds what is the result?
The calculator I see says $100 bet at 7/1 odds returns me $800. So I am assuming it is 100 x 7 = 700 plus I get my $100 bet back?

Not sure how I could code that in a formula. Or what is the odds were 13/2 and I bet $100 Helppppppppppppppppppppppppp

Thanks Anyone for your help

 

[Fluff]

It will be 100*13/2 + 100

 

[jasonb75]

To do it as a formula, with the 'odds' using a custom format of ?/?

Book1
	A	B
2	100.00	100.00
3	7/1	13/2
4	800.00	750.00
Sheet1

Cell Formulas
Range	Formula
A4:B4	A4	=A2*A3+A2

 

[RudeBoy]

It will be 100*13/2 + 100

Hmm I received a #VALUE! error I had Cell B11 = 100 and E11 = 13/2 and Formula in H11 like this =B11*E11+B11

Thanks for your Helppppppppppp

 

[RudeBoy]

It says for the #VALUE! error "A value used in the formula is of the wrong data type" Not sure how to fix this?

 

[RudeBoy]

400

13/2

#VALUE!​

 

[jasonb75]

If you got a #VALUE! error then one (or more) of the cells contains text, not a number.

Thanks for your Helppppppppppp

There's only 1 'p' in help

 

[RudeBoy]

Ok I got it thanks Everyone!!