Results 1 to 4 of 4

Thread: Nested function?

  1. #1
    Neophyte Basic93's Avatar
    Join Date
    Jun 2018
    Posts
    1
    Articles
    0
    Excel Version
    2010

    Nested function?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, I would like to ask you regarding with the excel conditional function. For example, I have multiple arguments for the date reminder as below for manual entry date in B column.
    =IF(OR(ISBLANK(B2)),"",IF(B2-TODAY()<7,"Alert", IF(B2-TODAY()<14,"Coming Soon","")))
    However, I want to add one more argument from different column, which has conflict to one of the IF conditionals. If the date in D column is the same or before the dates that entered in B column, then I wanna have as a "complete". Thank you.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Do you mean?

    =IF(ISBLANK(B2),"",IF(D2<=B2,"Complete",IF(B2-TODAY()<7,"Alert",IF(B2-TODAY()<14,"Coming Soon",""))))


  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    Another approach, which allows to you change/add extra conditions easily:
    =IF(ISBLANK(B2),"",IF(D2<=B2,"Complete",INDEX({"Overdue","Alert","Coming Soon",""},MATCH(B2-TODAY(),{-9000000,0,7,14}))))

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.reddit.com/r/best/commen...sted_function/
    Basic93, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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