#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Blank Suppression

How do I (blank) suppress a subtotal value that I have formatted as
0.00? Using #.## leaves the "." in the cell. The formula is below:
=SUMIF($E$401:$E$598, E399, $B$401:$B$598)

I want the cell to show blanks if no value is produced. Please
advise. TIA
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Blank Suppression

Mike Copeland explained on 7/6/2011 :
How do I (blank) suppress a subtotal value that I have formatted as
0.00? Using #.## leaves the "." in the cell. The formula is below:
=SUMIF($E$401:$E$598, E399, $B$401:$B$598)

I want the cell to show blanks if no value is produced. Please
advise. TIA


=IF(SUMIF($E$401:$E$598, E399, $B$401:$B$598)0,SUMIF($E$401:$E$598,
E399, $B$401:$B$598),"")

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Blank Suppression

Hi Mike,

Am Wed, 6 Jul 2011 07:24:04 -0700 schrieb Mike Copeland:

How do I (blank) suppress a subtotal value that I have formatted as
0.00? Using #.## leaves the "." in the cell. The formula is below:
=SUMIF($E$401:$E$598, E399, $B$401:$B$598)


custom format:
0.00;-0.00;


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Blank Suppression

How do I (blank) suppress a subtotal value that I have formatted as
0.00? Using #.## leaves the "." in the cell. The formula is below:
=SUMIF($E$401:$E$598, E399, $B$401:$B$598)


custom format:
0.00;-0.00;

Perfect! Thanks, Claus. 8<}}
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Suppression Gaffnr Excel Worksheet Functions 1 February 8th 08 06:22 PM
Concatenate with gap suppression! Bretter99 Excel Discussion (Misc queries) 4 July 25th 07 01:32 PM
Chart suppression of zero's ncalpaperboy Charts and Charting in Excel 2 May 22nd 07 03:00 PM
zero suppression on opening .xls file don Setting up and Configuration of Excel 1 October 26th 05 03:52 PM
Zero Suppression Irene Excel Discussion (Misc queries) 4 June 24th 05 10:21 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"