Thread: excel rand() negative
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default excel rand() negative
This was a bug in an early version of xl2003:

http://support.microsoft.com/kb/834520
The RAND function returns negative numbers in Excel 2003

http://support.microsoft.com/kb/828795/
Description of the RAND function in Excel 2003

But one of the service packs fixed it:
http://support.microsoft.com/ph/2512?sid=202


Rustin wrote:

When I run the equation =rand() sometimes I get a negative number, when I
should get a number between 0 and 1. Am I doing something wrong or is this a
glitch? I am running excel 2003.

--

Dave Peterson
Reply With QuoteReply With Quote