I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a multiplier
it multiplies by one. In other words, the cell isn't functioning by giving me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.

Hi Nat,
Excel help says that RANDBETWEEN returns a random integer between the
parameters specified. The number 1 is the only integer bewteen your
parameters and is the correct and only possible value that could be returned.
--
Ken Hudson


"Nat" wrote:

I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a multiplier
it multiplies by one. In other words, the cell isn't functioning by giving me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.

Hi. Hmmm. Help in Excel 2003 doesn't actually say that it returns
Integers.
If you do the following, and copy down, you will see that it only returns
Integer values.

=RANDBETWEEN(1,100)

Maybe something like:
=0.9+RAND()*0.2

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.

Hi Dana,
Copied from my Excel 2003 help:

"Returns a random integer number between the numbers you specify. A new
random integer number is returned every time the worksheet is calculated.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in."


--
Ken Hudson


"Dana DeLouis" wrote:

Hi. Hmmm. Help in Excel 2003 doesn't actually say that it returns
Integers.
If you do the following, and copy down, you will see that it only returns
Integer values.

=RANDBETWEEN(1,100)

Maybe something like:
=0.9+RAND()*0.2

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.

Copied from my Excel 2003 help: "Returns a random integer number ..."

Hi Ken. I read your post right after I sent mine.
Well this is strange. My help is really missing the word "integer." It
just says "random number."

Here's a copy...
"Returns a random number between the numbers you specify. A new random
number is returned every time the worksheet is calculated."

Hmmm. That's weird. Thanks for the feedback. :)

--
Dana DeLouis
Windows XP & Office 2003


"Ken Hudson" wrote in message
...
Hi Dana,
Copied from my Excel 2003 help:

"Returns a random integer number between the numbers you specify. A new
random integer number is returned every time the worksheet is calculated.

If this function is not available, and returns the #NAME? error, install
and
load the Analysis ToolPak add-in."


--
Ken Hudson


"Dana DeLouis" wrote:

Hi. Hmmm. Help in Excel 2003 doesn't actually say that it returns
Integers.
If you do the following, and copy down, you will see that it only returns
Integer values.

=RANDBETWEEN(1,100)

Maybe something like:
=0.9+RAND()*0.2

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function.
I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't
active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by
giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that
I
have to hit to get the function to operate - but I don't know what it
is.

I hit the send button too soon. I meant to include that "integer" is
mention in my Syntax section though.

RANDBETWEEN(bottom,top)
Bottom is the smallest integer RANDBETWEEN will return.
Top is the largest integer RANDBETWEEN will return.

So I guess I misread the help.
I stopped after reading "Returns a random number ..."
wheras I could have sworn it use to say "Returns a random integer number..."
like you mentioned.
--
Dana DeLouis
Windows XP & Office 2003

<snip

Here's a copy...
"Returns a random number between the numbers you specify. A new random
number is returned every time the worksheet is calculated."

What happens when you hit <F9?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.

*Without* using the ATP and RandBetween,
Use this formula:

=RAND()*(b-a)+a

Where "b" is the upper value, and "a" is the lower value.

So, this is what you want:

=RAND()*(1.1-0.9)+0.9

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
What happens when you hit <F9?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by
giving me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.