Insert function - doesn't include all functions??

[Hall]

In a cell, enter "=". Then use the insert-function list on the top-left
above the A column, which shows the last functions used. At the bottom of
this list is "More Functions..." which helps you find the function you want,
by category, say.

But this insert-function tool doesn't have all the available functions! For
example, Workday and Networkdays are excluded. I wonder what else is
excluded. How many times I've been trying to fund a function to do
something and gave up because I couldn't seem to find it. Yet the Help
feature seems to have these missing functions.

Can the list be refreshed with the complete list? Is there an Excel update
for this?

Thanks!

[Chip Pearson]

> For example, Workday and Networkdays are excluded.

Functions that a part of the Analysis Took Pak, as are WORKDAY
and NETWORKDAYS, are not listed in function list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hall" <hall@garp.org> wrote in message
news:O2s3TsoTGHA.5044@TK2MSFTNGP09.phx.gbl...
> In a cell, enter "=". Then use the insert-function list on the
> top-left above the A column, which shows the last functions
> used. At the bottom of this list is "More Functions..." which
> helps you find the function you want, by category, say.
>
> But this insert-function tool doesn't have all the available
> functions! For example, Workday and Networkdays are excluded.
> I wonder what else is excluded. How many times I've been
> trying to fund a function to do something and gave up because I
> couldn't seem to find it. Yet the Help feature seems to have
> these missing functions.
>
> Can the list be refreshed with the complete list? Is there an
> Excel update for this?
>
> Thanks!
>

[Dave Peterson]

Do you have the analysis pack selected in Tools|Addins?

I see both those workday and networkdays when I've turned that on (xl2003).

Hall wrote:
>
> In a cell, enter "=". Then use the insert-function list on the top-left
> above the A column, which shows the last functions used. At the bottom of
> this list is "More Functions..." which helps you find the function you want,
> by category, say.
>
> But this insert-function tool doesn't have all the available functions! For
> example, Workday and Networkdays are excluded. I wonder what else is
> excluded. How many times I've been trying to fund a function to do
> something and gave up because I couldn't seem to find it. Yet the Help
> feature seems to have these missing functions.
>
> Can the list be refreshed with the complete list? Is there an Excel update
> for this?
>
> Thanks!

--

Dave Peterson

[Dave Peterson]

In xl2003, there's an option for All the functions. That's where these Analysis
Toolpak showed up.



Dave Peterson wrote:
>
> Do you have the analysis pack selected in Tools|Addins?
>
> I see both those workday and networkdays when I've turned that on (xl2003).
>
> Hall wrote:
> >
> > In a cell, enter "=". Then use the insert-function list on the top-left
> > above the A column, which shows the last functions used. At the bottom of
> > this list is "More Functions..." which helps you find the function you want,
> > by category, say.
> >
> > But this insert-function tool doesn't have all the available functions! For
> > example, Workday and Networkdays are excluded. I wonder what else is
> > excluded. How many times I've been trying to fund a function to do
> > something and gave up because I couldn't seem to find it. Yet the Help
> > feature seems to have these missing functions.
> >
> > Can the list be refreshed with the complete list? Is there an Excel update
> > for this?
> >
> > Thanks!
>
> --
>
> Dave Peterson

--

Dave Peterson

[Hall]

Perfect. Thanks!
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4422BB01.F3116D4D@verizonXSPAM.net...
> Do you have the analysis pack selected in Tools|Addins?
>
> I see both those workday and networkdays when I've turned that on
> (xl2003).
>
> Hall wrote:
>>
>> In a cell, enter "=". Then use the insert-function list on the top-left
>> above the A column, which shows the last functions used. At the bottom
>> of
>> this list is "More Functions..." which helps you find the function you
>> want,
>> by category, say.
>>
>> But this insert-function tool doesn't have all the available functions!
>> For
>> example, Workday and Networkdays are excluded. I wonder what else is
>> excluded. How many times I've been trying to fund a function to do
>> something and gave up because I couldn't seem to find it. Yet the Help
>> feature seems to have these missing functions.
>>
>> Can the list be refreshed with the complete list? Is there an Excel
>> update
>> for this?
>>
>> Thanks!
>
> --
>
> Dave Peterson