Hi


"Mike H" wrote in message
...
Hi,

=100.008 on my machine

Then there went something wrong in your calculations - I get exactly 100 in
N1 [N1=SUM(B1:M1)]. The formula is self-adjusting.




I think the issue here is that the OP doesn't want to change the 8.333 in
cells B1 - M1 and by doing it using ROUND anything after .333 is lost yet
still expects it to add up to the original 100.

It was somewhere said, that happiness is when what you want mathces with
what you get :-)))



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )