Remove Zero Formula
On Tue, 7 Apr 2009 12:33:01 -0700, TGalin
wrote:
How can I change this formula =SUM(B5:D5) so that it will return a blank cell
instead of a zero if B5:D5 is empty?
Put it inside an IF statement that tests for it, and returns "" instead
of 0.
|