Comment 1 for bug 107700

Revision history for this message
Philip Paquette (pcpaquette) wrote :

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.