+ Reply to Thread
Results 1 to 5 of 5

Isblank

  1. #1
    Registered User
    Join Date
    10-29-2020
    Location
    Clearwater
    MS-Off Ver
    Office 365
    Posts
    5

    Isblank

    Hi,

    I have a formula that I am trying to get it to return a blank if the referenced cell is blank. 03 would be a date, but if the row is blank then 03 is blank and it returns warranty expired all the way down the column. I want it to be blank until a date is entered in to cell 03.

    Thanks in advance.
    Debbie


    =IF(TODAY()-O3>=365, "WARRANTY EXPIRED", "WARRANTY VALID")

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Isblank

    Try this:

    =IF(O3="","",IF(TODAY()-O3>=365, "WARRANTY EXPIRED", "WARRANTY VALID") )

    The parts shown in red are what you need to add to your existing formula.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-29-2020
    Location
    Clearwater
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Isblank

    not sure how i let members know, I solved the formula.

    =IF(O2="","",IF(TODAY()-O2>=365,"WARRANTY EXPIRED","WARRANTY VALID"))

  4. #4
    Registered User
    Join Date
    10-29-2020
    Location
    Clearwater
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Isblank

    oh, thank you Pete. that is the correction i needed.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Isblank

    You're welcome - glad to help.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2017, 12:26 PM
  2. [SOLVED] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 02:37 PM
  3. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  4. [SOLVED] If(ISBLANK)
    By Blue Hornet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  5. [SOLVED] If(ISBLANK)
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  6. If(ISBLANK)
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. If(ISBLANK)
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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