#N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))),"#N/A",((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)))
 
=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
http://PeltierTech.com/
_______
 
Back
Top