Thread: Random numbers to make a known amount
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smeeg
 
Posts: n/a
Default Random numbers to make a known amount

Hi there,

In cell A11 I have the value 100

Is there a formula I can put in A1:10 which has random numbers in it
(to 2 decimal places) which totals 100?

Thanks,

AJ


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

Reply With QuoteReply With Quote