+ Reply to Thread
Results 1 to 2 of 2

Blank Cell

  1. #1
    Registered User
    Join Date
    06-06-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    86

    Blank Cell

    Hello
    =IF(C5="","",IF(AND($C$2="C",C5="C"),"C1",IF(C5=$C$2,1,0)))
    How can I modify this formula in order to show a blank cell instead 0 before the formula get performed.
    Thanks.

  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,501

    Re: Blank Cell

    I am having trouble understanding your request.
    to put it in a narrative form, your formula says that, first if C5 is blank, leave the target cell blank, otherwise, second if both C2 and C5 equal "C" to make the target cell C1, lastly if C5 equals C2, return 1, otherwise return 0.
    so
    How can I modify this formula in order to show a blank cell instead 0 before the formula get performed.
    what part are you asking this about, the last part -- which is the only part with a 0? or what does before the formula get performed mean?

    could you clarify or post a small sample with formula AND desired result? instructions for uploading a workbook are at the top of the post in the yellow banner.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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] IF Cell is blank, calculate, if cell isn't blank, leave blank
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2015, 03:54 PM
  2. Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 11:31 PM
  3. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  4. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  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. If cell blank OR another cell blank then show blank, if not display value
    By stevop622 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2013, 04:07 AM
  7. [SOLVED] If one cell contains #, & other cell is blank, show message & require blank be resolved
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-19-2012, 02:23 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