Results 1 to 3 of 3

Thread: Nested If Statement Help

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

    Question Nested If Statement Help



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

    I have columns that give me a days remaining and the column before that gives me 90/60/30 day warning.

    A B C
    1 20090602 30 DAYS 16
    2 20181112 0 -181
    3

    C1 is =(C1)-NOW()

    What I would like to do do is when it's negative, it will display "OVERDUE"
    Can somebody help?

    Thank you!

    -Michael

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

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

  3. #3
    Neophyte DUSTWUN's Avatar
    Join Date
    May 2019
    Posts
    2
    Articles
    0
    Excel Version
    2019
    Thank you. That works.

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
  •