Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using RANDBETWEEN function in Excel 2003

Status
Not open for further replies.
DennisFromBoulder

DennisFromBoulder

Instructor
Jan 21, 2004
6
0
0
US
The RANDBETWEEN function, which generates integer random numbers within a range, does not work in Excel 2003. As in previous versions, it's part of the Analysis ToolPak add-in, but in 2003, installing the Analysis ToolPak does NOT activate RANDBETWEEN. I assume this is one of those oversights that Microsoft will fix. Does anybody know of this problem?. Sure, I can use a workaround (the RAND function with a multiplier and the INT function and all that), but I want RANDBETWEEN the way I've been using it for the last seven years.

 
Sort by date Sort by votes
I see you already got it working, but if you ever need it, Rand() can be used also, like this:

=INT(RAND()*1000), with 1000 being the maximum number.

ChaZ

Ascii dumb question, get a dumb Ansi
 
Upvote 0 Downvote
You should be aware that Microsoft changed the calculation engine that generates the random numbers in Office 2003, and inadvertantly left it with a bug that will eventually generate negative numbers with enough successive iterations. They are working on a fix that is currently in beta, and that should be released soon. This also affects RANDBETWEEN, so be careful depending on what you are using it for.

Regards
Ken................

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

----------------------------------------------------------------------------
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
483
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
54
arvarr
arvarr
Bijugate
  • Question
Excel update question
Replies
0
Views
92
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
95
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top