Excel Help Required

[LeTiss]

I have a sheet that I've been using for 'in play' markets. The command works fine, but it fails to fire the bet. The status cell says FAILED, and the description says - Your bet cannot be accepted, please check bet size.

I don't understand what the problem is, the bets don't exceed my balance or liability settings

[Nero Tulip]

Check the bet isn't less than £2, and also if your stake is arrived at via calculations in other cells / sheets, make sure you are using "ROUND(...,2)" to arrive at your stake with 2 decimal places. Use ROUND in the formulas instead of formatting the cells, this will make sure they are rounded and not simply displaying 2 decimals of what is still a number with lots of decmial places. Hope this helps.

[LeTiss]

Thanks for your help, ROUND function has solved my problems

Thanks again for the reply