Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?
Excel 2007 - How do I ignore zero's and #DIV/0! for a graph?
example:
you have data that looks something like this:
week # 1 2 3 4 5 6
PTP% 10% 13% 0% 0% #DIV/0! 0 %
Then graph the PTP% across from week 1 which is 10% to week 6 which is 0%
On the graph all u will see is the plots from week 1 & 2.
But then you will see the charted line drop to zero from Week #2.
My ? is does anyone know the formula i could use if the cells are zero or #DIV/0! leave blank?
Nesting more than 3 formulas sounds like the best way for this to work correctly.
Any ideas would be great thanks.
Jared~
Software/Hardware used:
Software/Hardware used:
ASKED:
February 10, 2009 8:10 PM
UPDATED:
February 22, 2009 1:07 PM
Answer Wiki:
I am not pretty clear about your query. However, you want to have blank in cell instead of Div/0 error.
You can use the formula mentioned below
suppose A1 has numerator values and B1 has denominator value which does not exist or is zero. So you have Div/0 error in C1 which has formula A1/B1
=IF(ISERROR(A1/B1), "", A1/B1)
The formula will return blank is there is any error while dividing.
If this resolve your issue. Do let me know
Regards,
Sarfaraz Ahmed
<a href="http://findsarfaraz.blogspot.com%2
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
