conditionally filling a cell with blank

Discussion in 'Mac Apps and Mac App Store' started by renzach, Mar 27, 2010.

  1. renzach macrumors newbie

    Mar 23, 2010
    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,

  2. ergdegdeg Moderator emeritus


    Oct 13, 2007
    You're probably looking for something like this:

    =IF([condition],"",[value of the cell or whatever you want])
  3. renzach thread starter macrumors newbie

    Mar 23, 2010
    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


Share This Page