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 ?
|