+ Reply to Thread
Results 1 to 3 of 3

Multiple Conditions on an IF statement

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Multiple Conditions on an IF statement

    Hi,

    This may be very easy or at the same time not possible, but i appreciate the help.

    I have the following

    G2 - Calculates the days before or after a date in M2, if cell T2 is blank, if populated with a date, it clears the cell.

    Formula: =IF(T2="",NETWORKDAYS(NOW(),M2),"")

    What i want to achieve on top of this, when M2 is empty G2 defaults to -49827 days, i would like for this to default to "TBC"

    I have attempted this but cannot get it to work. to note cell U2 uses the following to calculate target date difference in days.

    Any clues?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Multiple Conditions on an IF statement

    Perhaps

    =IF(M2="","TBC",IF(T2="",NETWORKDAYS(NOW(),M2),""))

    which is simply

    If M2 is blank then TBC, otherwise your G2 formula
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    03-13-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Multiple Conditions on an IF statement

    Superb. Thanks

+ 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. IF Statement with Multiple Conditions and Multiple True/False Results
    By ellesutgr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2015, 04:51 PM
  2. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  3. multiple conditions within an IF-THEN statement
    By ezdizzy in forum Excel General
    Replies: 2
    Last Post: 01-13-2009, 06:32 PM
  4. [SOLVED] If statement using multiple conditions
    By SCOOBYDOO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] If statement using multiple conditions
    By SCOOBYDOO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 01:05 AM
  6. Multiple Conditions in an IF statement
    By ClarissaG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2005, 01:44 PM
  7. Multiple conditions for IF statement
    By guilbj2 in forum Excel General
    Replies: 3
    Last Post: 01-10-2005, 01:52 PM

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