Divide and round
Hi
It's because all cells in range B1:M1 are divided down, i.e.
ROUND(0.33333333333333,3)=0.333.
To avoid this, some cells must be rounded to 0.334. One possible solution:
B1=ROUND($A$1/12,3)
C1=ROUND(($A$1-SUM($B$1:B$1))/(12-COLUMN()+2),3)
, and copy C1 to range C1:M1
Now the sum in N1 will be exactly 100
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"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
|