Comment 3 for bug 107700

The function I've used with my classroom was =ENT(ALEA()*6+1) so it was
near yours. But some children said me they had 7 as result once or twice
among 10000, what I've seen. It wasn't the lastest version of
openoffice, and it was under Windows XP. Under Linux, and 2.0.4, I've
not had this problem.

To have what I want, I've finally used =ALEA.ENTRE.BORNES(1;6) but it
wasn't very interesting to teach this way...

Thank's for your response, and sorry for my english.

Sébastien DUMORTIER.

Le jeudi 19 avril 2007 à 13:24 +0000, Philip Paquette a écrit :
> 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.
>
> ** Changed in: openoffice.org (Ubuntu)
> Status: Unconfirmed => Rejected
>