conditionally filling a cell with blank

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

  1. renzach macrumors newbie

    Joined:
    Mar 23, 2010
    #1
    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
     
  2. ergdegdeg Moderator emeritus

    ergdegdeg

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

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

    Joined:
    Mar 23, 2010
    #3
    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.
     

Share This Page