RANDBETWEEN() Function problem

[CR Optiker]

Using Excel 2002, SP-2.

I had been using the function Randbetween() with no problems, but when I
now either try to use it again on another worksheet, or even change the
formula that I am already using, it gives me a #VALUE error, and I haven't
been able to track the problem down. For example, my existing cell that
works (unless anything in it is changed) is...

=INT((Randbetween(13,(117-O10)))/13)

where O10 is a cell containing a simple integer (12 in this case). If I
change anything in the formula, it gives me the #VALUE error. I have
entered a simple Randbetween formula with only two simple numbers for the
lower and upper limits, in an empty area, and still get the error. When
entering that formula, for example Randbetween(0,10), using the wizard for
data formula entry rather than jsut typing into the cell, it shows the
correct answer in the wizard dialog box, but when I enter, it pops up the
#VALUE error.

Any suggestions?

Thanks!
Optiker

 

[Juan Sanchez]

Optiker

=RANDBETWEEN is part of the Analysis Toolpak Add-Inn, if
its not working any more try going to TOOLS.ADD-INS and
see if the Analysis Toolpak box is cheked (Usually the
second from top to bottom).

That should do the trick, if you still have problems
please reply...

Cheers
Juan

 

[CR Optiker]

Optiker

=RANDBETWEEN is part of the Analysis Toolpak Add-Inn, if
its not working any more try going to TOOLS.ADD-INS and
see if the Analysis Toolpak box is cheked (Usually the
second from top to bottom).

That should do the trick, if you still have problems
please reply...

Cheers
Juan

Juan...Thanks! That did it. Can't imagine how it got un-checked, but
apparently it did.

Optiker