Hi there,

I've put these values in cells A1:A10 (obviously with the = in front of
each formula)

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)
RAND()*100-SUM(A$2:A9)

But the total of A2:A10 never equals 100

Am I doing somthing wrong?

Thanks,


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