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 > -- random numbers https://bugs.launchpad.net/bugs/107700 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
