randbetween function

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

Hello, I have several files which use the randbetween function. I just
got a new machine and therefore a new install of the MS office
applications and excel doesn't seem to recognize the randbetween
function at all. I have the macros set to low and I have the add-ins
installed. Is this an obsolete function or something? I searched the
help for an alternative and it still has randbetween in there...
Help would be greatly appreciated,
Tracey
 
The ATP is already installed, sorry that's what I meant when I said
add-ins are installed. That is why I am perplexed about
this...randbetween should work with once the ATP is installed and I've
rebooted too.
Anyone???
 
Randbetween is certainly not an obsolete function, I'm using it in Excel
2003.

Can you use any other Analysis ToolPak functions,

ISEVEN
EDATE
etc.?

Have you tried uninstalling and re-installing?

If you can't get it to work you can always use RAND() to replicate
RANDBETWEEN, e.g.

=RANDBETWEEN(1,10) is the same as

=INT(RAND()*10)+1
 
Hello, I have several files which use the randbetween function. I just
got a new machine and therefore a new install of the MS office
applications and excel doesn't seem to recognize the randbetween
function at all. I have the macros set to low and I have the add-ins
installed. Is this an obsolete function or something? I searched the
help for an alternative and it still has randbetween in there...
Help would be greatly appreciated,
Tracey
Click to expand...

RANDBETWEEN requires that the Analysis Toolpack addin be available. Go to
Tools|Addins and check its box.
 
Back
Top