Random Numbers

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

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
 
Use RANDBETWEEN(0,9) as the formula

regards
Anirudh

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
Click to expand...

Hi RANDBETWEEN(0,9) gives #NAME? however I solved it, I needed to put
=RAND()*9

Thanks Tracy
 
RandBetween requires the Analysis Toolpack to be installed. Sorry... Should
have added that...
 
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)
 
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
 
I am using Office 2003 Excel <- Randbetween is an Excel 2007 function

Tyro
 
RandBetween is an Excel 2007 function. The OP said I am using Office 2003
Excel

Use RANDBETWEEN(0,9) as the formula

regards
Anirudh
 
RandBetween is an Excel 2007 Function. The Op said: I am using Office 2003
Excel
 
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


---
 
=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.
 
Yea thaty was the reason for my question. I have it on xl2k.

Mike Rogers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Function 2
Excel Repeating a RAND() function under certain conditions 0
RAND() result changes when other cells are used in worksheet. 3
How can I fill a block of 300 cells with non-repeating random #s 2
help on summing a random combination 1
Random number generation - with no repeats 3
Random Numbers 4
reffering another cell value which contains RAND() 0

Back
Top