Thread
:
Remove Zero Formula
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
UpGrade
external usenet poster
Posts: 10
Remove Zero Formula
On Tue, 07 Apr 2009 14:38:58 -0600, Glenn wrote:
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?
=IF(your_formula=0,"",your_formula)
Exactly.
Reply With Quote
UpGrade
View Public Profile
Find all posts by UpGrade