I get some negative numbers when I use the RAND() function--Why?

  • Thread starter Thread starter Guest
  • Start date Start date
I think that this was a problem in early versions of xl2003.

There was a service pack that fixed this problem.

If you click on Help|about, what version (including service pack) do you see?

If it's xl2003 and not SP2, then it's off to microsoft.com to get the update.
 
Thanks Dave, All I see when I look in About is "Microsoft Office Excel 2003"

When I check my System Info, Version list "5.1.2600 service Pack 2 Build 2600"

Is this what you are talking about or is there a specify SP for Excel? If
so, where on the site can I find the update?

Thx again... dave-
 
I would have guessed that one of the SP's included that fix, but glad you got it
working.
 
You must log in or register to reply here.

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

eliminate negative value from normal random number distribution 4
Excel Repeating a RAND() function under certain conditions 0
reffering another cell value which contains RAND() 0
Red cell for negative numbers in Excel 1
How to get repeatable Excel RAND sequence? 12
Questions about RAND() function 2
Adding Random Numbers 22
What does Excel's RAND function really do 0

Back
Top