Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBERS?
Need to generate a random number of either 0 or 1 but completely
rounded, no decimal points just a whole number. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBERS?
OMG
=INT(0+(1-0+1)*RAND()) But te (1-0+1) makes no sense...explains? On Fri, 10 Oct 2008 22:43:11 -0400, Robert Blass sayd the following: Need to generate a random number of either 0 or 1 but completely rounded, no decimal points just a whole number. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBERS?
Since it's impossible for a computer to make a random number then how
can we do this for real? I only have a computer to use. thanks On Fri, 10 Oct 2008 22:43:11 -0400, Robert Blass sayd the following: Need to generate a random number of either 0 or 1 but completely rounded, no decimal points just a whole number. thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBERS?
=RANDBETWEEN(0,1)
"Robert Blass" wrote: Need to generate a random number of either 0 or 1 but completely rounded, no decimal points just a whole number. thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBERS?
ok, tanks a lots!
On Sat, 11 Oct 2008 02:43:00 -0700, Teethless mama sayd the following: =RANDBETWEEN(0,1) "Robert Blass" wrote: Need to generate a random number of either 0 or 1 but completely rounded, no decimal points just a whole number. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |