Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on anoth
I am using an excel file that I've placed on a shared server folder. I
created the original file, Three other people have access to the file. When information is enter into the cells from two of the three they get an $names error message in the formualted cells. But, if I open it and look at the cells they changed the caculation they entered appears correct on my computer. The obvious thought is that we're using different versions of excel or updates but we've check that and all on the same page. The physical computers are a bit older, but I'm not sure that should effect Excel. We've also made sure the box is checked to accept labels in the formulas. Here's a sampling of the formula =IF(F6="",(""),IF(F6="AD or Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter "AD or Email" into cell F6 but the folks with the problems are getting $names, while I'm seeing the date ( along with one of the other folks ). Any thoughts or help would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on anoth
ToolsAdd-ins, check Analysis Toolpak
-- Kind regards, Niek Otten Microsoft MVP - Excel "WKH" wrote in message ... |I am using an excel file that I've placed on a shared server folder. I | created the original file, Three other people have access to the file. When | information is enter into the cells from two of the three they get an $names | error message in the formualted cells. But, if I open it and look at the | cells they changed the caculation they entered appears correct on my | computer. The obvious thought is that we're using different versions of excel | or updates but we've check that and all on the same page. The physical | computers are a bit older, but I'm not sure that should effect Excel. We've | also made sure the box is checked to accept labels in the formulas. Here's a | sampling of the formula =IF(F6="",(""),IF(F6="AD or | Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter | "AD or Email" into cell F6 but the folks with the problems are getting | $names, while I'm seeing the date ( along with one of the other folks ). | | Any thoughts or help would be appreciated. | | Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on anoth
=IF(OR(F6={"AD","Email"}),WORKDAY(L6,-7,AB6:AN6),"") "WKH" wrote: I am using an excel file that I've placed on a shared server folder. I created the original file, Three other people have access to the file. When information is enter into the cells from two of the three they get an $names error message in the formualted cells. But, if I open it and look at the cells they changed the caculation they entered appears correct on my computer. The obvious thought is that we're using different versions of excel or updates but we've check that and all on the same page. The physical computers are a bit older, but I'm not sure that should effect Excel. We've also made sure the box is checked to accept labels in the formulas. Here's a sampling of the formula =IF(F6="",(""),IF(F6="AD or Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter "AD or Email" into cell F6 but the folks with the problems are getting $names, while I'm seeing the date ( along with one of the other folks ). Any thoughts or help would be appreciated. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on a
Thank you . This worked Perfect.
"Niek Otten" wrote: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "WKH" wrote in message ... |I am using an excel file that I've placed on a shared server folder. I | created the original file, Three other people have access to the file. When | information is enter into the cells from two of the three they get an $names | error message in the formualted cells. But, if I open it and look at the | cells they changed the caculation they entered appears correct on my | computer. The obvious thought is that we're using different versions of excel | or updates but we've check that and all on the same page. The physical | computers are a bit older, but I'm not sure that should effect Excel. We've | also made sure the box is checked to accept labels in the formulas. Here's a | sampling of the formula =IF(F6="",(""),IF(F6="AD or | Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter | "AD or Email" into cell F6 but the folks with the problems are getting | $names, while I'm seeing the date ( along with one of the other folks ). | | Any thoughts or help would be appreciated. | | Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on a
Thanks for the tip on the formula. That'll help me squeeze one more "if"
question into an already long formula. "Teethless mama" wrote: =IF(OR(F6={"AD","Email"}),WORKDAY(L6,-7,AB6:AN6),"") "WKH" wrote: I am using an excel file that I've placed on a shared server folder. I created the original file, Three other people have access to the file. When information is enter into the cells from two of the three they get an $names error message in the formualted cells. But, if I open it and look at the cells they changed the caculation they entered appears correct on my computer. The obvious thought is that we're using different versions of excel or updates but we've check that and all on the same page. The physical computers are a bit older, but I'm not sure that should effect Excel. We've also made sure the box is checked to accept labels in the formulas. Here's a sampling of the formula =IF(F6="",(""),IF(F6="AD or Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter "AD or Email" into cell F6 but the folks with the problems are getting $names, while I'm seeing the date ( along with one of the other folks ). Any thoughts or help would be appreciated. Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that calculate to errors on one computer but not on anoth
The WORKDAY formula requires the Analysis Toolpak add-in be enabled under
ToolsAdd-ins If you look up workday in help you would see that warning. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 07:20:02 -0800, WKH wrote: I am using an excel file that I've placed on a shared server folder. I created the original file, Three other people have access to the file. When information is enter into the cells from two of the three they get an $names error message in the formualted cells. But, if I open it and look at the cells they changed the caculation they entered appears correct on my computer. The obvious thought is that we're using different versions of excel or updates but we've check that and all on the same page. The physical computers are a bit older, but I'm not sure that should effect Excel. We've also made sure the box is checked to accept labels in the formulas. Here's a sampling of the formula =IF(F6="",(""),IF(F6="AD or Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter "AD or Email" into cell F6 but the folks with the problems are getting $names, while I'm seeing the date ( along with one of the other folks ). Any thoughts or help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
remove links when pasteing formulas from one workbook to anoth | Excel Worksheet Functions | |||
What is the function to calculate standard errors of the mean? | Excel Worksheet Functions | |||
Handling errors in formulas (how annoying are they!) | Excel Discussion (Misc queries) | |||
Errors in copying formulas | Excel Discussion (Misc queries) |