With other functions, you should be able to tweak it to your needs. For example, to obtain the dice side #, you might want to use:
=TRUNC(RAND()*6)+1
RAND() * 6 -> between 0,6 Trunc -> 0,1,2,3,4,5 +1 -> 1,2,3,4,5,6
The odds of arriving exactly at 1.00000000000000 are 0. Hope this helps. Rejecting.
With other functions, you should be able to tweak it to your needs.
For example, to obtain the dice side #, you might want to use:
=TRUNC(RAND()*6)+1
RAND() * 6 -> between 0,6
Trunc -> 0,1,2,3,4,5
+1 -> 1,2,3,4,5,6
The odds of arriving exactly at 1.00000000000000 are 0.
Hope this helps.
Rejecting.