Results 1 to 4 of 4

Thread: Nested if help

  1. #1
    Seeker DUSTWUN's Avatar
    Join Date
    May 2019
    Posts
    8
    Articles
    0
    Excel Version
    2019

    Nested if help



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

    I have a tracker that keeps up with people's tasks.

    A1= date task is completed in YYYYMMDD
    A2=adds 365 days to show next due date
    A3=shows 90/60/30/0 days based on A4
    A4=shows how many days left until it's due and when it hits 0(zero) it shows "OVERDUE"

    I have successfully used the formula. A4=IF((A3-NOW())<0,"OVERDUE",A3-NOW()) to show days left and OVERDUE

    My goal is when I initiated a task, I will enter, "INIT" in A1 and A4 will show "OVERDUE". A4=IF(A1="INIT","OVERDUE",0)

    Asking for assistance to have both IF statements in one cell.

    1 2 3 4
    A 20190101 20191231 0 OVERDUE
    B INIT OVERDUE


    Thank you for your help!

    -Michael

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,460
    Articles
    0
    Excel Version
    Office 365 Subscription
    Try this:

    =IF(A3="INIT","OVERDUE",IF((A3-NOW())<0,"OVERDUE",A3-NOW()))
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker DUSTWUN's Avatar
    Join Date
    May 2019
    Posts
    8
    Articles
    0
    Excel Version
    2019
    PERFECT!!! I had to tweak a cell location, but it's exactly what I needed and I just realized I had my table example reversed.

    Thanks for your help Ali!



    Quote Originally Posted by AliGW View Post
    Try this:

    =IF(A3="INIT","OVERDUE",IF((A3-NOW())<0,"OVERDUE",A3-NOW()))

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,460
    Articles
    0
    Excel Version
    Office 365 Subscription
    No worries.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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