View Single Post
  #3   Report Post  
RDM
 
Posts: n/a
Default

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 ?