+ Reply to Thread
Results 1 to 4 of 4

If 0.0% leave cell blank

  1. 04-05-2019, 03:58 PM #1
    rayman741
    rayman741 is offline
    Registered User
    Join Date
    03-11-2019
    Location
    netherlands
    MS-Off Ver
    excel
    Posts
    8

    If 0.0% leave cell blank

    Hi,

    If the cell contains 0.0% can you somehow have the cell shown as blank so that is doesn't count in other formulas like sum or average?
    Reply With QuoteRegister To Reply
  2. 04-05-2019, 04:02 PM #2
    Sam Capricci
    Sam Capricci is offline
    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: If 0.0% leave cell blank

    sure, =IF(your formula)=0,"",your formula. May need to add a couple parens and maybe based on your regional settings change the comma to a semicolon.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 04-06-2019, 12:37 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,942

    Re: If 0.0% leave cell blank

    It wont affect a SUM anyway, but can you show what actual formulas you might be using?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 04-06-2019, 02:50 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: If 0.0% leave cell blank

    You can always build formulas excluding null values or errors. Introducing the null text string, OTH, might get you in trouble later
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Leave cell blank if referenced cell and/or formula is blank or incomplete
    By alonsogar in forum Excel General
    Replies: 1
    Last Post: 06-29-2016, 03:44 AM
  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. IF Statement to leave cell blank if multiple cells are all blank
    By sweeteri in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2014, 12:02 PM
  4. [SOLVED] help on a simple if text says this input that, if cell is blank leave it blank
    By Rec1ne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 10:43 AM
  5. Create Quarter/Year Field, but if blank, either populate cell with ERROR or leave blank
    By maryren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2013, 01:43 PM
  6. [SOLVED] Simple pull exact text from cell, if blank it pulls up a 0. How to leave it as blank?
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 02:20 PM
  7. Excel 2007 : unable to leave cells blank if reference cell is blank
    By FluidicAztec in forum Excel General
    Replies: 4
    Last Post: 07-15-2008, 01:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1