Use NA() instead of "" or 0, it might look ugly but the chart will plot OK


=if(A5=0,NA(),if(B5=0,NA(),A5/B5))


--

Regards,

Peo Sjoblom


"RDM" wrote in message
...
the result of my formula
=if(A5=0,"",if(B5=0,"",A5/B5))
is not an empty cell, and I would like it to be an empty cell so that my
graph would not plot this point as a zéro

"bj" wrote:

go to <Tools<Options<chart and select plot empty cells either as not
ploted or as interpolated. ,(I appologize in that I don't know what
"recul"
means

"RDM" wrote:

Hello,
I would like to have en empty cell as recul instead of a zero or a ""
here is the formula I use :
=if(A5=0,"",if(B5=0,"",A5/B5))
I want to make a graph and when I have a blank my graph falls as if it
was a
zero
can anybody help me ?