software

I have a cell with the following formula:
{=AVERAGE(IF(B4:M4lt;gt;0,B4:M4))}
It's producing the infamous #DIV/0! error - When the cell produces this
error, I just want a dash in its place. How can this be done?

Thank you

Wrap it all in an if and test for an error:
=if(iserror(AVERAGE(IF(B4:M4lt;gt;0,B4:M4))),quot;-quot;,AVERAGE(IF(B4:M4lt;gt;0,B4:M4)))

Note: when using quot;-quot; keep in mind other formulas referring to this cell. If
you're doing a calculation then a quot;-quot; will produce an error.
You may be better setting the error value to 0 (zero) and using the
formatting to show a dash.

HTH

Giz

quot;Karenquot; wrote:

gt; I have a cell with the following formula:
gt; {=AVERAGE(IF(B4:M4lt;gt;0,B4:M4))}
gt; It's producing the infamous #DIV/0! error - When the cell produces this
gt; error, I just want a dash in its place. How can this be done?
gt;
gt; Thank you

Thank you for your help - I used this formula on a cell that should not
produce a zero, it should average the numbers and I'm getting a dash. Do you
know what is wrong?
Thank you

quot;Gizmo63quot; wrote:

gt; Wrap it all in an if and test for an error:
gt; =if(iserror(AVERAGE(IF(B4:M4lt;gt;0,B4:M4))),quot;-quot;,AVERAGE(IF(B4:M4lt;gt;0,B4:M4)))
gt;
gt; Note: when using quot;-quot; keep in mind other formulas referring to this cell. If
gt; you're doing a calculation then a quot;-quot; will produce an error.
gt; You may be better setting the error value to 0 (zero) and using the
gt; formatting to show a dash.
gt;
gt; HTH
gt;
gt; Giz
gt;
gt; quot;Karenquot; wrote:
gt;
gt; gt; I have a cell with the following formula:
gt; gt; {=AVERAGE(IF(B4:M4lt;gt;0,B4:M4))}
gt; gt; It's producing the infamous #DIV/0! error - When the cell produces this
gt; gt; error, I just want a dash in its place. How can this be done?
gt; gt;
gt; gt; Thank you

Thank you - It works great!
It wasn't working before because I didn't Ctrl Shift Enter
Thanks again

quot;Gizmo63quot; wrote:

gt; Wrap it all in an if and test for an error:
gt; =if(iserror(AVERAGE(IF(B4:M4lt;gt;0,B4:M4))),quot;-quot;,AVERAGE(IF(B4:M4lt;gt;0,B4:M4)))
gt;
gt; Note: when using quot;-quot; keep in mind other formulas referring to this cell. If
gt; you're doing a calculation then a quot;-quot; will produce an error.
gt; You may be better setting the error value to 0 (zero) and using the
gt; formatting to show a dash.
gt;
gt; HTH
gt;
gt; Giz
gt;
gt; quot;Karenquot; wrote:
gt;
gt; gt; I have a cell with the following formula:
gt; gt; {=AVERAGE(IF(B4:M4lt;gt;0,B4:M4))}
gt; gt; It's producing the infamous #DIV/0! error - When the cell produces this
gt; gt; error, I just want a dash in its place. How can this be done?
gt; gt;
gt; gt; Thank you