Nested IF statement works for me, but not for other users.

[Redpop]

Below is a formula that references a range on another tab, and uses 'IF' and 'NETWORKDAYS' functions. This formula (created in Excel 2003) works for me but not for my intended users using Excel 2000 and 2003.

It comes from a project-tracking list, where column 'C' is the report date, 'H' is Finish Date, 'J' is the user's expected remaining project work hours. The range 'util!M$3:M$30' is a list of holidays on another tab. It has nested 'IF' statements to keep the report clean if neither comment is appropriate.

The idea is to flag missed due dates and improbable time allotments (72 hours of work to do in 2 more working days, etc).

=IF(H20>0,IF(H20>C20,IF(J20>0,IF(J20>(NETWORKDAYS(C20,H20,util!M$3:M$30))*8,"hours vs finish",""),""),"finish date"),"")

It seems that the problem is in the hours vs finish section, with the reference to the util tab. It displays a #NAME? error, but just for users other than myself. Is the formula trying to reference my computer? If so, wouldn't it display an absolute reference path in their formula bar?

Thank you for having a look.

 

[AnotherHiggins]

NETWORKDAYS is part of the Analysis ToolPak add-in. If other users don't have that enabled, their Excel won't know that function.

Go to Tools > Add-Ins and check the box beside Analysis ToolPak.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Redpop]

Wow. Just like that, huh?
I tried this on one of the other users' computers, and it's exactly as you say. Thanks so much for the help!

 

[AnotherHiggins]

Glad to help!


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.