You won't get arithmetic like that to work out exactly, as $100/12 cannot be
represented exactly in fixed-point binary, any more than it can in
fixed-point decimal.

You can get it closer if in B1 to M1 you don't put the rounded number
=ROUND($A1/12,3), but instead just use =$A1/12 and format the cell to
display to 3 decimal places.
--
David Biddulph

"osaka78" wrote in message
...
if any one can help

e.g i have $100 in A1 and like to divide it by 12 and round the figure to
3
decimal place and put the result in B1 to M1 and then total of (B1:M1)in
N1
the result is $99.996 how can i make it $100 without manually changing the
figures in B1:M1

Regards