+ Reply to Thread
Results 1 to 3 of 3

Choose option 2 of IF Statement if cell is blank

  1. #1
    Registered User
    Join Date
    04-20-2021
    Location
    Sacramento, CA
    MS-Off Ver
    O365
    Posts
    2

    Choose option 2 of IF Statement if cell is blank

    I have an IF statement in cell E4 that will populate text for true or false based on a date in cell D3. The statement is looking to see if the date is older than 30 days, if so, enter text "Follow up to letter 1", if false, "No follow up needed for Letter 1". I'd like to have cell E4 display the False condition is there is NO date in D4. How can I accomplish this? Please see my attachment.
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Choose option 2 of IF Statement if cell is blank

    just put this if statement in front of it...

    =IF(D4="","",IF(AND($D4 < TODAY()-30, $Q4="No"), "Follow Up to Letter 1","No Follow Up Needed for Letter 1"))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-20-2021
    Location
    Sacramento, CA
    MS-Off Ver
    O365
    Posts
    2

    Re: Choose option 2 of IF Statement if cell is blank

    Thanks! This is the solution!

+ 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. [SOLVED] Choose and option and lock another
    By caet_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2020, 11:11 PM
  2. [SOLVED] ActiveX Button to choose blank cell and fill with value from other sheet
    By yabastud in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2017, 10:42 AM
  3. Two validations: first choose the sheet (1-5), then choose the option
    By bee88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 08:12 AM
  4. [SOLVED] Choose the same option for all lists with a button
    By HugoRibeiro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 11:31 AM
  5. [SOLVED] If statement that copies text from a separate worksheet, or if blank, leaves cell blank.
    By barleycorn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2012, 12:30 PM
  6. The option to choose data in Excel?
    By danakajoel in forum Excel General
    Replies: 4
    Last Post: 05-06-2010, 06:00 AM
  7. specify option to choose on alert msg?
    By ricksimm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2005, 03:05 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