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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs