Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
#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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
#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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|