status failure

[wbabc]

why does my formula for stake not work in live mode - it works in training mode
command line is IF(AND(BB$25<10,BB$24<=BB$23,BB$32<BB$21,I8=SMALL(I$8:I$13,1)),"back",IF(AND(BB$25<10,BB$24<=BB$23,BB$32<BB$21,I8=SMALL(I$8:I$13,2)),"back",""))
stake line is IF(AND(I8=SMALL(I$8:I$13,1),BA8="back"),BB$34,IF(AND(I8=SMALL(I$8:I$13,2),BA8="back"),BB$35,""))

hopeful for correction or explanation if possible
thanks

[Gavin]

Hi wbabc,

I'm guessing that you might have forgotten to round the stake sizes to whole currency units (for example, up to the next nearest pence).

Your formula for stake should be surrounded by the ROUND() function, with comma 2 just inside the closing bracket, for example:
=ROUND(IF(AND(I8=SMALL(I$8:I$13,1),BA8="back"),BB$34,IF(AND(I8=SMALL(I$8:I$13,2),BA8="back"),BB$35,"")),2)

Kind regards,

Gavin

[wbabc]

Thanks Gavin for your prompt and spot on observation - rounding was the answer 10/10