software

I could probably find the answer to this question if I only new the right
terms to search by. My problem is I have a sheet where I have values in
cells b3 through m3. I then average those values in cell n3. I have
multiple(many) rows so I dragged this formula down to the bottom. The
problem is that for any rows where I don't have data in the b through m cells
the cell(n3) displays #DIV/0!. Is there a way to write the formula so that
it will be blank unless data is entered into b3 through m3? This is really
only a cosmetic issue as I could easily delete those formulas where I don't
yet have data and drag them in when I do but that isn't the most elegant
solution.

Any help?


Try this:

=IF(ISERR(your formula),quot;quot;,your formula)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=523724Try this:

=IF(ISERROR(formula),quot;quot;,formula)

Replace the word formula with whatever formula you're currently using.

HTH,
Elkarquot;Mattquot; wrote:

gt; I could probably find the answer to this question if I only new the right
gt; terms to search by. My problem is I have a sheet where I have values in
gt; cells b3 through m3. I then average those values in cell n3. I have
gt; multiple(many) rows so I dragged this formula down to the bottom. The
gt; problem is that for any rows where I don't have data in the b through m cells
gt; the cell(n3) displays #DIV/0!. Is there a way to write the formula so that
gt; it will be blank unless data is entered into b3 through m3? This is really
gt; only a cosmetic issue as I could easily delete those formulas where I don't
gt; yet have data and drag them in when I do but that isn't the most elegant
gt; solution.
gt;
gt; Any help?

Thanks to both of you that worked.

quot;Elkarquot; wrote:

gt; Try this:
gt;
gt; =IF(ISERROR(formula),quot;quot;,formula)
gt;
gt; Replace the word formula with whatever formula you're currently using.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Mattquot; wrote:
gt;
gt; gt; I could probably find the answer to this question if I only new the right
gt; gt; terms to search by. My problem is I have a sheet where I have values in
gt; gt; cells b3 through m3. I then average those values in cell n3. I have
gt; gt; multiple(many) rows so I dragged this formula down to the bottom. The
gt; gt; problem is that for any rows where I don't have data in the b through m cells
gt; gt; the cell(n3) displays #DIV/0!. Is there a way to write the formula so that
gt; gt; it will be blank unless data is entered into b3 through m3? This is really
gt; gt; only a cosmetic issue as I could easily delete those formulas where I don't
gt; gt; yet have data and drag them in when I do but that isn't the most elegant
gt; gt; solution.
gt; gt;
gt; gt; Any help?

Another way is to look at the quantity of numbers in that range:

=if(count(b3:m3)=0,quot;No numbersquot;,average(b3:m3))Matt wrote:
gt;
gt; I could probably find the answer to this question if I only new the right
gt; terms to search by. My problem is I have a sheet where I have values in
gt; cells b3 through m3. I then average those values in cell n3. I have
gt; multiple(many) rows so I dragged this formula down to the bottom. The
gt; problem is that for any rows where I don't have data in the b through m cells
gt; the cell(n3) displays #DIV/0!. Is there a way to write the formula so that
gt; it will be blank unless data is entered into b3 through m3? This is really
gt; only a cosmetic issue as I could easily delete those formulas where I don't
gt; yet have data and drag them in when I do but that isn't the most elegant
gt; solution.
gt;
gt; Any help?

--

Dave Peterson