Greetings! Have created a custom field in a pivottable whose zeros are
configured to be displayed as blank cells. The custom field uses an
=IF(A,B,C) formula. If I don't define C, then the cell appears to be
populated with zero, and displays as such in spite of the pivottable
setting.

Question: is there some function, or constant, that can be used in C such
that there is no value applied to that cell from the formula and it displays
as a blank, not a zero? Empty() and Null() don't work.

Played with this a little, determined that I can apply a custom display
format to the field where zero's aren't displayed, but would like to handle
this via a persistent formula rather than a back-end display format.

Thanks for any ideas!
George