Hi -
I am trying to use an if statement in combination with a networkdays statement. the if statment tells me whether to multiple by 8 (hours) for an external vendor versus 6 (hours) for an internal resource. I think the statement below is close, but not working. Any help is appreciated.
=IF(E6="External",(networkdays((h6,i6)*8),(networkdays((h6,i6)*6)))
Brandon
Bookmarks