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

Formula error with Mac resulting in '#NAME' error
 

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 ,
"Linking to specific cells in pivot table"
crosoft.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) )

Formula error with Mac resulting in '#NAME' error
 

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 ,
"Linking to specific cells in pivot table"
crosoft.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) )