Formula error with Mac resulting in '#NAME' error

Hi,

A client of mine is having problems with a spreadsheet I put together on
their Mac -- apparently, the following formula (entered into a cell in the
spreadsheet) is resulting in the '#NAME' error -- I'm wondering if this has
to do with the fact they're using a Mac. Does anyone know? And if so, is
there a solution? In general, is there a place to go to troubleshoot Mac
Excel issues?

Thanks!

Robert

=IF(Proj.Mngt.!B23="","",WORKDAY(Proj.Mngt.!B23,2))

> In general, is there a place to go to troubleshoot Mac Excel issues?

Well, yes. Try Excel Help. The WORKDAY() function's entry includes:

> If this function is not available, and returns the #NAME? error, install and
> load the Analysis ToolPak add-in.

along with the instructions for how to load it (varies depending on the
MacXL version).


In article <3B6FF9E6-4C9D-4F9B-8811-2B020DB7BC96@microsoft.com>,
"Linking to specific cells in pivot table"
<Linkingtospecificcellsinpivottable@discussions.microsoft.com> wrote:

> Hi,
>
> A client of mine is having problems with a spreadsheet I put together on
> their Mac -- apparently, the following formula (entered into a cell in the
> spreadsheet) is resulting in the '#NAME' error -- I'm wondering if this has
> to do with the fact they're using a Mac. Does anyone know? And if so, is
> there a solution? In general, is there a place to go to troubleshoot Mac
> Excel issues?
>
> Thanks!
>
> Robert
>
> =IF(Proj.Mngt.!B23="","",WORKDAY(Proj.Mngt.!B23,2))

Thanks!

"JE McGimpsey" wrote:

> > In general, is there a place to go to troubleshoot Mac Excel issues?
>
> Well, yes. Try Excel Help. The WORKDAY() function's entry includes:
>
> > If this function is not available, and returns the #NAME? error, install and
> > load the Analysis ToolPak add-in.
>
> along with the instructions for how to load it (varies depending on the
> MacXL version).
>
>
> In article <3B6FF9E6-4C9D-4F9B-8811-2B020DB7BC96@microsoft.com>,
> "Linking to specific cells in pivot table"
> <Linkingtospecificcellsinpivottable@discussions.microsoft.com> wrote:
>
> > Hi,
> >
> > A client of mine is having problems with a spreadsheet I put together on
> > their Mac -- apparently, the following formula (entered into a cell in the
> > spreadsheet) is resulting in the '#NAME' error -- I'm wondering if this has
> > to do with the fact they're using a Mac. Does anyone know? And if so, is
> > there a solution? In general, is there a place to go to troubleshoot Mac
> > Excel issues?
> >
> > Thanks!
> >
> > Robert
> >
> > =IF(Proj.Mngt.!B23="","",WORKDAY(Proj.Mngt.!B23,2))
>