+ Reply to Thread
Results 1 to 8 of 8

Keeping it blank!!!

  1. #1
    Registered User
    Join Date
    04-26-2005
    Posts
    43

    Keeping it blank!!!

    How do I keep a cell blank if it is equal to 0?

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    On the main menu, select Tools>Options. On the View tab, uncheck 'Zero Values', click OK.

    HTH

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Registered User
    Join Date
    04-26-2005
    Posts
    43

    Another question for you???

    How do I only designate a column with blank zero values? It did the whole sheet.

  4. #4
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Sorry, you didn't specify to limit it to an area.

    You will need to recheck the 'zero values' box in Options, then modify your formulas.

    The new formula would look like this:

    =IF(<yourcurrentformula>=0,"",<yourcurrentformula>)

    HTH

    Bruce

  5. #5
    Registered User
    Join Date
    04-26-2005
    Posts
    43

    Sorry, but another question

    I currently have this formula ,=IF(H2>8,H2-8,0), in that cell. How do I also implement the other formula together?

  6. #6
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    like this:

    =IF(H2>8,H2-8,"")

    Simple?

  7. #7
    Registered User
    Join Date
    04-26-2005
    Posts
    43

    Thanks so much

    Thank you very much for your help!!!

  8. #8
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545

    You're Welcome

    No problem. Glad it worked out for you. Thanks for the feedback.

    Cheers!

    Bruce

+ 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