Need a formla for if 0.00 return a blank or sum a range

**SueMac** · 11-20-2012, 01:32 PM

Looking to create one formula in A2 based on the following:
If A1 is 0.00, return a blank in cell A2 or if cell A1 has a value great than 0, sum a range in A2
Any suggestions?

Thanks
Sue

**Richard Buttrey** · 11-20-2012, 01:34 PM

Hi,

Presumably something like
=IF(A1=0,"",SUM(A10:A100)

**TheExcelphile** · 11-20-2012, 02:02 PM

Hi Sue,

Richard is right, what you need is the IF formula.

Here is an article I had written on IF. You could pick up a few pointers...

**SueMac** · 11-20-2012, 02:31 PM

Worked like a charm, thanks everyone! Very helpful

Need a formla for if 0.00 return a blank or sum a range

LinkBack

Thread Tools

Rate This Thread

Display

Need a formla for if 0.00 return a blank or sum a range

Re: Need a formla for if 0.00 return a blank or sum a range

Re: Need a formla for if 0.00 return a blank or sum a range

Re: Need a formla for if 0.00 return a blank or sum a range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions