|
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 |
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 |
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 |
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 |
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 |
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 |
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 - |
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 |
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 |
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 |
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 |
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 --- |
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 |
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 |
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 |
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 --- |
| All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com