+ Reply to Thread
Results 1 to 2 of 2

'Greater than' comparison with NETWORKDAYS not working

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Wales
    MS-Off Ver
    Excel for Office 365
    Posts
    4

    'Greater than' comparison with NETWORKDAYS not working

    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!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-26-2016
    Location
    UK
    MS-Off Ver
    O365
    Posts
    260

    Re: 'Greater than' comparison with NETWORKDAYS not working

    Column E's formulae return text, not numbers:
    =IF(D2="Medium", "20",IF(D2="High", "7",IF(D2="Low","40","")))
    needs to be:
    =IF(D2="Medium", 20,IF(D2="High", 7,IF(D2="Low",40,"")))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-25-2018, 09:08 PM
  2. Networkdays function not working?
    By sherringtonjr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2013, 11:01 AM
  3. NETWORKDAYS only working on VBE
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-29-2011, 11:51 AM
  4. greater than comparison not doing anything
    By sulavsingh6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 02:56 PM
  5. NETWORKDAYS not working
    By corinereyes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2007, 08:06 AM
  6. =NETWORKDAYS not working as expected and as it once did
    By USAOz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2006, 10:05 AM
  7. [SOLVED] Networkdays Function Not Working
    By Al H. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1