#NAME? Error occurs on one machine but not another.

[thehead]

Hi,

I have a created a spreadsheet which takes information from a SQL database and then checks the dates to how long it has taken my company to complete each call we take.

On my machine the spreadsheet works fine, (I have Excel XP) however whenever I move it to another machine (the other machines have Excel 2k) it throws up #NAME? errors whenever there is a call which failed to acheive its target time. The formula which gives the error is included below.

=IF(H5<>NULL, IF(INT(B5)=INT(H5),ROUND(24*(H5-B5),2),(24*(DayEnd-DayStart)*(MAX(NETWORKDAYS(B5+1,H5-1,HolidayList),0)+INT(24*(((H5-INT(H5))-(B5-INT(B5)))+(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(ROUND(((24*(H5-INT(H5)))-24*DayStart)+(24*DayEnd-(24*(B5-INT(B5)))),2),ROUND((24*(DayEnd-DayStart)),2)))), NULL)

B5 = 12/03/2002 16:11:00
H5 = 13/03/2002 11:08:23
DayStart = 08:00
DayEnd = 18:00
HolidayList is an empty cell.

If you have any ideas then please let me know this is driving me crazy!

Tom. Webmaster of

http://www.netepic.org

The EPICentre and owner of Minatures Online. (10% off all VOID goods!)

 

[SkipVought]

Hi,
NETWORKDAYS is an ADD-IN - Analysis Toolpack.

Is that add-in installed on the other machine? Skip,
metzgsk@voughtaircraft.com

 

[SkipVought]

Also, NULL is not a spreadsheet value in Excle 2K. You might need to use &quot;&quot;. Skip,
metzgsk@voughtaircraft.com

 

[thehead]

Hi,

Sorry I forgot to mention, NULL is the cell name for an empty cell in my workbook.

I have installed the Analysis Toolpak on there machines and it works fine. Thanks for all the help guys I was beginning to tear my hair out here!

Tom. Webmaster of

http://www.netepic.org

The EPICentre and owner of Minatures Online. (10% off all VOID goods!)

 

[euskadi]

I have Excel 2k and NETWORKDAYS is a big show-stopper on my machine. Perhaps it's in the EXCEL XL addin, but not in mine.