conditionally filling a cell with blank

[renzach]

Hi,
I would like to fill some cells in numbers conditionally with blank. These cells are in a table which is used to fill one chart. So I dont want the cells to have a value of zero. Alternatively, is there a function which returns the value in a cell?


Many thanks in advance,

Zach

 

[ergdegdeg]

You're probably looking for something like this:

=IF([condition],"",[value of the cell or whatever you want])

 

[renzach]

Thank you,

I found another way. I conditionally gave the data T(cell) where cell is an empty cell elsewhere. Your solution is right one.
However, my attempt to feed the chart with blanks did not work. Chart by default gives zero to all blank cells.


Thanks to you again

zach.