Simple Spreadsheet formula assitance

[Alpha322]

Can some spreadsheet wizard help me out here. I want to show the odds of 6.0 in a cell. We know that 6.0 on Betfair is 5/1 .
So £100 x 5 = £500, but show it as £100 x 6.0 =500 what is the formula for that? Anyone know
Many thanks

[woodhousejj]

Hi

Formula is BF Decimal Odds x Stake minus Stake. 6.0 X £100 - £100 = £500

Regards
John

[THENUTS]

unless its a trick question if cell A1 contains the value 100 and cell B1 contains the value 6 then :

=A1*(B1-1)

[markjacks]

Hi Alpha322, were you able to sort this out? Would be nice if you can share the actual formula that you entered.

[Alpha322]

unless its a trick question if cell A1 contains the value 100 and cell B1 contains the value 6 then :

=A1*(B1-1)

Many Thanks Nuts the above is the formula.

[Alpha322]

Hi Alpha322, were you able to sort this out? Would be nice if you can share the actual formula that you entered.

It is as Nuts has put it