by 100%beef » Wed Dec 28, 2005 3:54 pm
opps just seen a topic about this please ignore!!!!!
Hi!
I have a problem with the stake column, I lay to set liability and if I put an if statement in the stake colunm to work out my bet size such as: =IF(20/(J5-1)>=2,20/(J5-1),2)
this provides a stake size to produce a liability of £20, however if I use this and trigger a bet I always get "please check bet size as an error"
I have the format of the cells set to 2 decimal places even tried 1 and no decimal places and I still get the same error. Also tried formatting the cell as a currency with still no joy.
If I just type the number in and do not use a formula then it works fine.
Any ideas anyone?
Many thanks
opps just seen a topic about this please ignore!!!!!
Work facinates me I can stare at it for hours.