You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, download files, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact contact us.
Anyone direct me to Excel random numbers software please?
I wish to use my hx4700 as a...wait for it....Bingo calling tool, randomly select from 90 numbers. for coach trip.....nothing too fancy.
Currently I have used the basic excel (rand)function, but curious to find a more "automatic" formulae. I understand I am unable to use macros on my Ipaq.
I have MS Office Pro 2003 on my desktop with Win XP, where I use spreadsheets regularly.
TIA
Terry
Unfortunately, I do not know of any random number generating software for Excel mobile. However, the following formula will give you a random number between one and 90 within the cell.
=Int(90*Rand())+1
To force recalculation click within the formula (located in upper right of Excel application) then click the check mark. There may be another way to force recalculation however I don't know what it is.
If this looks as if it might be adequate for you let me know and I'll spend some time being sure that the probability of getting a 1 or a 90 is the same as that of getting the numbers between.
Anyone direct me to Excel random numbers software please?
Linear Mode
