View Single Post
  #1   Report Post  
inkpassion
 
Posts: n/a
Default Random Values totaling Cell value


What Im looking to do is have 2 cells 1 with the number of random
numbers and 2 the total value of these numbers. I need the random
numbers to be 1-6.

Something like this:

Coins Value
4 10

C1 C2 C3 C4
1 4 3 2


What would the formula be to accomplish this?



--
inkpassion
------------------------------------------------------------------------
inkpassion's Profile: http://www.excelforum.com/member.php...o&userid=16972
View this thread: http://www.excelforum.com/showthread...hreadid=401757