Results 1 to 8 of 8

How to return blank instead of zero?

Threaded View

  1. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to return blank instead of zero?

    The easiest way is probably to go to File - Options - Advanced and Uncheck "Show a zero in cells that have zero value"

    But you can do it in the formula too if you like

    Try
    =IFERROR(1/(1/SUMIFS(Data!$E:$E,Data!$C:$C,'CG Template'!$B6,Data!$D:$D,'CG Template'!$F6,Data!$A:$A,'CG Template'!K$4,Data!$B:$B,'CG Template'!$G$3)),"")
    Last edited by Jonmo1; 12-14-2015 at 01:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  2. [SOLVED] Go to right thru a range and skip all blank cells, return value of first non-blank in rang
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2015, 03:47 PM
  3. Replies: 10
    Last Post: 09-12-2015, 02:04 PM
  4. [SOLVED] When my formula encounters a blank cell it returns a 0, I need it to return a blank
    By stretch99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2014, 07:52 PM
  5. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  6. Replies: 4
    Last Post: 07-23-2012, 04:54 PM
  7. Replies: 3
    Last Post: 11-22-2007, 07:53 AM

Tags for this Thread

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