do other functions from the analysis toolpack work?
Networkdays() etc.
try reinstalling and reloading analysis toolpack?

=22+floor(rand()*4.9999999999999,1) is approximately the same as
randbetween(22,226)

"Dave F" wrote:

Using this formula,
=IF(K2="BER",randbetween(22,26),randbetween(35,37) )

I get the #NAME? error.

Analysis toolpak is installed. Using a work pc with XL 03 and relying
on company IT department to solve this issue is not in the cards.

SO, how can this formula be rewritten using the RAND function?
Presumably some combination of RAND and INT but I'm not sure.

Thanks.

Dave