| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random Numbers
Hi how can I put random numbers from 0 to 9 in cells B2:B27?
I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Give this a try...
=RANDBETWEEN(0,9) -- HTH... Jim Thomlinson "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Use RANDBETWEEN(0,9) as the formula
regards Anirudh On Jan 11, 5:01*am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
"Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy Hi RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put =RAND()*9 Thanks Tracy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
RandBetween requires the Analysis Toolpack to be installed. Sorry... Should
have added that... -- HTH... Jim Thomlinson "Tracy" wrote: "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy Hi RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put =RAND()*9 Thanks Tracy |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Rand() * 9 does not give you integers but rather it gives you decimal
numbers. To do it that way you should use =round(rand() * 9, 0) -- HTH... Jim Thomlinson "Tracy" wrote: "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy Hi RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put =RAND()*9 Thanks Tracy |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
I don't think Analysis tool pak is required as RANDBETWEEN is a
standard 2003 function . However you should put an = sign before randbetween formula mentioned above HTH Regards Anirudh On Jan 11, 6:02*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: RandBetween requires the Analysis Toolpack to be installed. Sorry... Should have added that... -- HTH... Jim Thomlinson "Tracy" wrote: "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy Hi *RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put =RAND()*9 Thanks Tracy- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
I am using Office 2003 Excel <- Randbetween is an Excel 2007 function
Tyro "Jim Thomlinson" wrote in message ... Give this a try... =RANDBETWEEN(0,9) -- HTH... Jim Thomlinson "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
RandBetween is an Excel 2007 function. The OP said I am using Office 2003
Excel "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
RandBetween is an Excel 2007 Function. The Op said: I am using Office 2003
Excel "Tracy" wrote in message ... "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy Hi RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put =RAND()*9 Thanks Tracy |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Tyro
Are you sure Randbetween is ONLY in 2007? Mike Rogers "Tyro" wrote: I am using Office 2003 Excel <- Randbetween is an Excel 2007 function Tyro "Jim Thomlinson" wrote in message ... Give this a try... =RANDBETWEEN(0,9) -- HTH... Jim Thomlinson "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
I am using Office 2003 Excel <- Randbetween is an Excel 2007 function
RANDBETWEEN is available in xl2003, it just requires the Analysis Toolpak* be installed and activated. Check the "Analysis Toolpak" box via Tools Add-Ins Chip Pearson's page has details on the ATP at: http://www.cpearson.com/excel/ATP.htm -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
"Tyro" wrote in message
. net... I am using Office 2003 Excel <- Randbetween is an Excel 2007 function Tyro "Jim Thomlinson" wrote in message ... Give this a try... =RANDBETWEEN(0,9) -- HTH... Jim Thomlinson Funny thing, I have RANDBETWEEN in Excel 2002! -- James Silverton Potomac, Maryland |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
=randbetween() is included in the analysis toolpak in xl2003 and below.
All the worksheet functions in that analyis toolpak were moved into excel proper with xl2007. Tyro wrote: RandBetween is an Excel 2007 function. The OP said I am using Office 2003 Excel "Ag" wrote in message ... Use RANDBETWEEN(0,9) as the formula regards Anirudh On Jan 11, 5:01 am, "Tracy" wrote: Hi how can I put random numbers from 0 to 9 in cells B2:B27? I tried highlighting the cells and and entering =RAND() and Ctrl+c but I only get 1's and 0's in the cells. I am using Office 2003 Excel Thanks Tracy -- Dave Peterson |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Yea thaty was the reason for my question. I have it on xl2k.
Mike Rogers "James Silverton" wrote: "Tyro" wrote in message . net... I am using Office 2003 Excel <- Randbetween is an Excel 2007 function Tyro "Jim Thomlinson" wrote in message ... Give this a try... =RANDBETWEEN(0,9) -- HTH... Jim Thomlinson Funny thing, I have RANDBETWEEN in Excel 2002! -- James Silverton Potomac, Maryland |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random Numbers
Chip Pearson's page has details on the "Analysis Toolpak" at:
http://www.cpearson.com/excel/ATP.htm You need to install and activate it .. Check the "Analysis Toolpak" box via Tools Add-Ins -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| 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 | |||
| How to select top six numbers from a of range of random 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) | |||
![Tracy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
