Null value with Numbers

Discussion in 'iPad General Discussions' started by Coolwhipl, May 8, 2011.

  1. Coolwhipl

    Coolwhipl iPF Noob

    Joined:
    May 8, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Redmond, wa
    Ratings:
    +0 / 0
    I am building a little spreadsheet that needs to find if an adjacent cell has a value. Then make a calculation using that value or leave blank. It seems like an easy question, but this is my first time using Numbers and the solution escapes me. Here is my formula (the one that does not work)

    If(isblank(B2),null,(238-B2)/238)

    If B2 is blank then enter a null value, else run the calculation. If B2 is blank, then the current cell should be null or blank.
    Any ideas?
     
  2. GlennTX

    GlennTX iPF Novice

    Joined:
    May 29, 2010
    Messages:
    12
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I use excell so I'm not too sure about numbers but I think your use of the word "null" is what is tripping you up.

    Substitute an empty set of quotes in place of the word "null" and see if it helps.

    If(isblank(B2),"",(238-B2)/238)
     
  3. Coolwhipl

    Coolwhipl iPF Noob

    Joined:
    May 8, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Redmond, wa
    Ratings:
    +0 / 0
    That did it. Double quotes. Thank you. Numbers is actually pretty powerful, if you just know the tricks.
     

Share This Page

Search tags for this page
apple numbers if blank
,

apple numbers if cell is empty

,

apple numbers leaving a cell with no value

,
apple numbers null
,

apple numbers null value

,
blank values in numbers iworks
,
how to show null in apple numbers app
,

nil statements in numbers mac

,

null value in numbers

,
numbers spreadsheet formula detect null