Activating Function

[Guest]

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.

 

[Guest]

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.

 

[Dana DeLouis]

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

 

[RagDyer]

What happens when you hit <F9>?

 

[Guest]

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

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

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.

 

[RagDyer]

*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 !
---------------------------------------------------------------------------

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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.

 

[Dana DeLouis]

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

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

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

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.

 

[Dana DeLouis]

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.