#N/A
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 |
#N/A
=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),#N/A,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
"Arturo" wrote: 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 |
#N/A
=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/ _______ "Arturo" wrote in message ... 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 |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com