+ Reply to Thread
Results 1 to 6 of 6

create empty cell if a table has blank cell

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    create empty cell if a table has blank cell

    I have a workbook with many worksheets.

    The primary worksheet simply rearranges selected data from the other worksheets, and then performs calculations on the selected data.

    The other worksheets have simple tables.

    If a table has an integer, then I want that integer to be copied to the main worksheet. I have no problems with this simple formula.... BUT if the original table has an empty cell, the primary worksheet shows a "0" which in turn corrupts other forumlas.

    I need a formula to create an empty cell rather than a "0." I've attached a sample workbook to illustrate my question.

    Thanks!
    Attached Files Attached Files
    Last edited by jrtaylor; 03-04-2011 at 05:53 PM. Reason: Solved. Thanks!

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: create empty cell if a table has blank cell

    In your example, your original table has a 0 in it, it's not empty. Going by that assumption (if it's empty or has a zero in it),

    =IF('Raw Data Worksheet'!L8<>0,'Raw Data Worksheet'!L8,"")

    does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: create empty cell if a table has blank cell

    In Excel 2007:
    Click the Office Button->Excel Options->Advanced category.
    Look for "Display options for this worksheet"
    Uncheck the "Show a zero in cells that have zero value" check box.

    In Excel 2003:
    Remove the tick from the “Zero Values” check box in the Tools – Options – View dialog box.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: create empty cell if a table has blank cell

    Blake, the OP did state that the 0 is corrupting his other formulas so simply masking it won't suffice.

  5. #5
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: create empty cell if a table has blank cell

    ahh - you are right! good point.... in that case I recommmend

    =IF('Raw Data Worksheet'!L8<>0,'Raw Data Worksheet'!L8,"")

  6. #6
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Re: create empty cell if a table has blank cell

    Thanks! You solved the prob.

    Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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