« Averaging non-zero values | Main | Data Filtering : AutoFilter »
September 27, 2004
Printing only non-zero values
Sometimes it may be desirable to filter out "0" return values from functions and formulas to avoid messy and cluttered spreadsheets.A simple and effective way to do this is to use the IF function as is illustrated in the example below.
For cells D7 and D11, we do not get a "0" - which is the desired effect.
In fact, the general form of the IF function that achieves this effect is.. =IF([formula];[formula];"")
Posted by Dave at September 27, 2004 03:24 AM
Comments
You can also do this in "Format Cells", with the
following "user defined" format
0;0;""
or for something more complicated .. a dollar amount (with -ve in Red)
[>0][$$-409]#,##0.00;[
Posted by: Michael Katzmann at October 31, 2004 03:50 AM