Formula error with Mac resulting in '#NAME' error

[Guest]

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))

 

[JE McGimpsey]

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).


"Linking to specific cells in pivot table"

 

[Guest]

Thanks!

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


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


"Linking to specific cells in pivot table"