| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting negative random numbers - HELP!
I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by definition it should only generate numbers between 0 and 1. Any suggestions? Thanks in advance. Susan Forson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting negative random numbers - HELP!
You are correct, by definition it should return a (positive) value between 0
and 1. Are you certain the formula in the cell is =RAND() if it has any other paramters, that may be affecting your results? "SusanForson" wrote: I must be crazy, but I am using the RAND() function and it occasionally generates a negative number. I cannot find any information on this - by definition it should only generate numbers between 0 and 1. Any suggestions? Thanks in advance. Susan Forson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting negative random numbers - HELP!
See this:
http://support.microsoft.com/kb/834520 Biff "SusanForson" wrote in message ... I must be crazy, but I am using the RAND() function and it occasionally generates a negative number. I cannot find any information on this - by definition it should only generate numbers between 0 and 1. Any suggestions? Thanks in advance. Susan Forson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting negative random numbers - HELP!
Great find! No wonder I couldn't duplicate it here (must have refreshed a
sheet 40 times trying) - I'm up to date on hotfixes. "Biff" wrote: See this: http://support.microsoft.com/kb/834520 Biff "SusanForson" wrote in message ... I must be crazy, but I am using the RAND() function and it occasionally generates a negative number. I cannot find any information on this - by definition it should only generate numbers between 0 and 1. Any suggestions? Thanks in advance. Susan Forson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting positive numbers to negative numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Displaying negative numbers - inconsistent between desktop and lap | Excel Discussion (Misc queries) | |||
| Formula to ignore negative numbers in a column? | Excel Worksheet Functions | |||
Linear Mode
