Computing.Net > Forums > Office Software > Excel Random Formula

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Random Formula

Reply to Message Icon

Name: jmorovich
Date: October 7, 2006 at 19:11:57 Pacific
OS: XP Pro
CPU/Ram: x
Product: x
Comment:

Is it possible to generate a formula for a cell in Excel 2003 to randomly pull a number from 1-15,000?

Thanks in advance.



Sponsored Link
Ads by Google

Response Number 1
Name: rhawk7938
Date: October 8, 2006 at 13:53:28 Pacific
Reply:

=round(rand()*(15000-1)+1,0)


0
Reply to Message Icon

Related Posts

See More


Blank bodies in emails Access - Calculate in rep...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel Random Formula

Excel random formula www.computing.net/answers/office/excel-random-formula/7854.html

Excel 2007 Formula Question www.computing.net/answers/office/excel-2007-formula-question/9280.html

Excel Spreadsheet Formula www.computing.net/answers/office/excel-spreadsheet-formula/9360.html