Surpressing zero in MS Excel 1

[scottd431]

Is there a way to tell a calcuated field to supress if it is equal to zero? I have done this with Crystal Reports which is very easy but never with Excel

 

[xlbo]

I'm guessing what you want is do-able but it depends what you mean by "supress" - if you want the row / column to not be shown at all or just to set a different cell to 0 if another one is.....

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[scottd431]

I want all values in each cell where the formula reside to show as long as they are greater than zero. If they are zero then the cell should just be blank. Thanks

 

[SkipVought]

Hi,

You can format the cell(s) with the Accounting built-in format and select no symbol.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ETID]

Try this...


as an example...

if i want to add cells in A1 and B1 and put the result in C1

the formula in c1 ... =A1+B1

to suppress if the result is zero... =if((A1+B1)=0,"",(A1+B1))

 

[Zathras]

OK, as long as we are all jumping in here...

Perhaps what you want is Tools/Options (View tab) Uncheck "Zero values"

 

[scottd431]

Thanks to all of your help. Once again trying to make something more difficult than it actually should be. I forgot to use the K.I.S.S. method thanks for the help. Did not even know that was under the Tools menu Thanks again

 

[SkipVought]

Scott,
Zero supression has nothing to do with a CALCULATED field.

You were specific.

Non-calculated fields with zeros should not be affected unless you asked to suppress ALL ZEROS.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com