RAND() in Excel 2003 returns values from -1 to +1

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

the RAND() Function in Excel 2003 now returns values from -
1 to +1 instead of from 0 to +1 as in previous versions.

If you want RAND() to work in the OLD way it will be
necessary to ABS it.

i.e. ABS(RAND())

Don.
 
Don,
What makes you think so?
Your comment is not in agreement with my experience. I have =RAND() in
A1:A1000
In B1 =COUNTIF(A1:A1000,">0")
With repetitive recals, this always returns value 1000 - i.e. no negative
values.

Bernard
 
Back
Top