Hi,

=100.008 on my machine

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.

I'm minded of the person asking for directions to the Whitehouse and being
told that you shouldn't really start from here.

Mike

"Arvi Laanemets" wrote:

Hi again

You can do it with a single formula for range B1:M1 too:
B1=ROUND((2*$A$1-SUM($A$1:A$1))/(12-COLUMN()+2),3)
and copy to B1:M1


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