G
Guest
I have graphs for which values will be filled in time, but befor it's filled
I want zeroes not to be visible. Is it posible?
I want zeroes not to be visible. Is it posible?
Andy Pope said:Hi,
You need to include a IF condition in you formula.
=IF(X1<>"",X1,NA())
So if the other cell, in this case X1, has a value use it otherwise use
the NA()
Cheers
Andy