a-ha! I see what I'm doing wrong - I used the wrong formula in the final
cell...

basically, this is what I should do:

=100.00
=RAND()*10
=RAND()*100-A2
=RAND()*100-SUM(A$2:A3)
=RAND()*100-SUM(A$2:A4)
=RAND()*100-SUM(A$2:A5)
=RAND()*100-SUM(A$2:A6)
=RAND()*100-SUM(A$2:A7)
=RAND()*100-SUM(A$2:A8)
=100-SUM(A$2:A9)

Thanks for your help.


--
Smeeg
------------------------------------------------------------------------
Smeeg's Profile: http://www.excelforum.com/member.php...o&userid=29099
View this thread: http://www.excelforum.com/showthread...hreadid=518655