| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) ) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) ) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If-Then-Else resulting in DIV/0 error | Excel Programming | |||
| If-Then-Else resulting in DIV/0 error | Excel Programming | |||
| If-Then-Else resulting in DIV/0 error | Excel Programming | |||
| If-Then-Else resulting in DIV/0 error | Excel Programming | |||
| If-Then-Else resulting in DIV/0 error | Excel Programming | |||
Hybrid Mode
