for Benny's sake i think i should point out that there is nothing wrong with using ROUNDUP -- my tip was in adopting a 0.5 adjustment to the equation -- i suggested using FLOOR as an alternative -- the same thing could also be achieved using INT -- the following all make the bet 2% of the bank rounded to "nearest" whole $1 (where cell H2 is the bank)

=ROUNDUP(0.02*H2-0.5,0)

=FLOOR(0.02*H2+0.5,1)

=INT(0.02*H2+0.5)

__________________
never smile at a crocodile -- don't be taken in by his welcome grin