Hi,
I'm trying to see if the NETWORKDAYS calculated number of days to do a task (column F) is greater than the target number of days we set (column E).
Here's the formula: =IF(C4="","",E4>=F4)
For every line it says TRUE, even for the ones where the task days is far greater than the target.
I'm using some formulas to hide the calculation if the task has not been done yet - I'm not sure if this is confusing things or not.
Please see the attached sample.
Thanks very much!
Bookmarks