+ Reply to Thread
Results 1 to 9 of 9

If cell is blank, use formula

  1. #1
    Registered User
    Join Date
    02-06-2017
    Location
    California, US
    MS-Off Ver
    Office 2016
    Posts
    38

    If cell is blank, use formula

    I would like to have a column display today's date only if a certain cell contains any character. If that certain cell is blank I would like then I would like this cell to be blank.

    for example: If cell A1 contains any character I would like Cell A3 to output the formula =TODAY(). If cell A1 is blank then I would like cell A3 to also be blank.

    I think in order to acomplish this I need the function in cell A3 to look something like this
    Please Login or Register  to view this content.
    Last edited by anthony777; 05-19-2017 at 06:04 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,370

    Re: If cell is blank, use formula

    Almost: A3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,370

    Re: If cell is blank, use formula

    Hello, and welcome to the forum.

    I note that you have marked the thread solved, so I'm guessing the solution I provided was what you were looking for.

    For future reference, it is not considered good etiquette (at least, I don't consider it good etiquette) to join a forum, ask a question, take the answer, and just vanish into the night. It is generally expected that you will, at least, provide some feedback (for example, it worked), maybe a "thank you" and, ideally, +rep the contributor(s) who helped you.

    If that expectation is consistently not met, you may find people become less willing to offer you help or advice.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: If cell is blank, use formula

    TMS, can I copy and use your post #3 sometimes?
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,370

    Re: If cell is blank, use formula

    @sandy666: wherever, and whenever you like. Be my guest.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,370

    Re: If cell is blank, use formula

    @anthony777: no pressure, but it seems that others share my sentiments

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: If cell is blank, use formula

    TMS,
    Many thanks

  8. #8
    Registered User
    Join Date
    02-06-2017
    Location
    California, US
    MS-Off Ver
    Office 2016
    Posts
    38

    Re: If cell is blank, use formula

    My appologies, the solution worked great thank you for your help and the advice.

    I usually respond expressing my gratitude but this post must have slipped through the cracks.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,370

    Re: If cell is blank, use formula

    You're welcome. Thanks for the rep.


    No worries. Thanks for following up.

+ 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. Replies: 1
    Last Post: 06-29-2016, 03:44 AM
  2. Replies: 11
    Last Post: 09-15-2014, 02:36 AM
  3. Replies: 5
    Last Post: 08-15-2014, 08:33 AM
  4. [SOLVED] If formula in one cell refers to another cell which is blank result is a blank cell
    By M-Tommo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2014, 08:29 AM
  5. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  6. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM
  7. I want a formula cell to be blank if cells computing formula are blank
    By asawyer3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2011, 05:24 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