David, yes I happened to do this, and it seemed to fix the problem.

Thanks, also, for your alternative formula.

Dave

On Jul 31, 11:58 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
There is a reported bug where even if Analysis toolpak is enabled it
occasionally fails to load. Sometimes closing Excel & reopening does the
trick, but otherwise it may be worth disabling then re-enabling the analysis
toolpak.

As far as your suggestion of RAND and INT is concerned, try
=IF(K2="BER",INT(22+5*RAND()),INT(35+3*RAND()))
--
David Biddulph

"Dave F" wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -