Analysis Toolpak Question

**mphell0** · 02-10-2006, 09:48 AM

I recently added the Analysis Tookpak and have noticed some problems.
When using functions from ATP it will not show a popup that shows what you
are supposed to put in the function.

For example if you type in =IF( it will show a window that says:

=IF(logical_test,[value_if_true],[value_if_false]) to remind you what to put in

but if you type in for instance =randbetween( nothing shows up.

I can go into the insert function menu to view the requirements but it is
much easier to have it show up on the screen when you are trying to
understand new functions. Is this just how it works or is it only happening on
my computer?

Bernard Liengme · 02-10-2006, 10:10 AM

That's the way it is.
You do know about typing, for example, =randbetween(
and then using CTRL+A to popup the Insert Function dialog?
According to the Excel12 blog, in the next version all function are created
equally
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mphell0" <[email protected]> wrote
in message news:[email protected]...
>
> I recently added the Analysis Tookpak and have noticed some problems.
> When using functions from ATP it will not show a popup that shows what
> you
> are supposed to put in the function.
>
> For example if you type in =IF( it will show a window that says:
>
> =IF(logical_test,[value_if_true],[value_if_false]) to remind you what
> to put in
>
> but if you type in for instance =randbetween( nothing shows up.
>
> I can go into the insert function menu to view the requirements but it
> is
> much easier to have it show up on the screen when you are trying to
> understand new functions. Is this just how it works or is it only
> happening on
> my computer?
>
>
> --
> mphell0
> ------------------------------------------------------------------------
> mphell0's Profile:
> http://www.excelforum.com/member.php...o&userid=30153
> View this thread: http://www.excelforum.com/showthread...hreadid=511029
>