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

[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.

 

[Bernard V Liengme]

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

 

[Guest]

Bernard,

Your comment is not in agreement with my experience.

Don.