software

My model is built.
Using #N/A - my chart displays perfectly, zeros suppressed.
This formula is what feeds the values in my chart series.
=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),””,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))

If I alter that error handling
to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),quot;#N/Aquot;,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
Zero still displays…
If I may ask – how would I alter this formula to function they way I hope it
would?

Sincerely,
Arturo

=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),#N/A,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
quot;Arturoquot; wrote:

gt; My model is built.
gt; Using #N/A - my chart displays perfectly, zeros suppressed.
gt; This formula is what feeds the values in my chart series.
gt; =IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),””,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
gt;
gt; If I alter that error handling
gt; to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),quot;#N/Aquot;,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
gt; Zero still displays…
gt; If I may ask – how would I alter this formula to function they way I hope it
gt; would?
gt;
gt; Sincerely,
gt; Arturo

=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),NA(),((AVERAGE(SHEET1!BE2:BM2))*(100/5)))

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Arturoquot; gt; wrote in message
...
gt; My model is built.
gt; Using #N/A - my chart displays perfectly, zeros suppressed.
gt; This formula is what feeds the values in my chart series.
gt; =IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),quot;quot;,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
gt;
gt; If I alter that error handling
gt; to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),quot;#N/Aquot;,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
gt; Zero still displays.
gt; If I may ask - how would I alter this formula to function they way I hope
gt; it
gt; would?
gt;
gt; Sincerely,
gt; Arturo