Divide and round
What you describe will add up to $100 in N1 unless you are doing something
else other than displaying the division results to 3 decimal places. To do
this format the cells to 3 decimal places and all should be OK
Mike
More info
"osaka78" wrote:
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
|