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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Repeating a RAND() function under certain conditions 0
Replace =RAND() with =ABS(RAND()) 24
How to get repeatable Excel RAND sequence? 12
What does Excel's RAND function really do 0
What does Excel's RAND function really do 4
Rand() formula 14
Excel 2000, RAND and IF functions do not work together for me 8
Rand between 1 and 50 9

Back
Top