| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
RAND() generates negative values???
I just tested RAND in Excel 2007 SP1 through 20 million iterations and did
not get a single negative number. -- Biff Microsoft Excel MVP "expect_ed" wrote in message ... Office 2007 - Even though the description says: "Returns a random number greate than or equal to 0 and less than 1, evenly distributed (changes on recalculation)." When I enter the formula and extend the cell down the column I get negative values. What gives? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
| I get some negative numbers when I use the RAND() function--Why? | Excel Worksheet Functions | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
Threaded Mode
