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];”")