Thread
:
Remove Zero Formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Glenn
external usenet poster
Posts: 1,240
Remove Zero Formula
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?
Or, maybe this:
=IF(COUNT(B5:D5)=0,"",SUM(B5:D5))
Reply With Quote
Glenn
View Public Profile
Find all posts by Glenn