Random Numbers

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
 
T

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

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

Thanks Tracy
 
J

Jim Thomlinson

RandBetween requires the Analysis Toolpack to be installed. Sorry... Should
have added that...
 
J

Jim Thomlinson

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)
 
A

Ag

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
 
T

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
 
M

Max

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
 
D

Dave Peterson

=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.
 

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

Top