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 1, 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.
Yes, certainly, but it wasn't this mistake ;-)
Le jeudi 19 avril 2007 à 13:27 +, Philip Paquette a écrit :
> Also,
>
> if you use the random normal generator and you don't set an approximate
> number of digits after the decimal, the output of rand() will be
> correct, but the cell will round