1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Null value with Numbers

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

  1. Coolwhipl
    Offline

    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
    Offline

    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
    Offline

    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 cell is empty

,

apple numbers null

,

apple numbers null value

,
average if not blank iwork numbers
,

blank values in numbers iworks

,

how to show null in apple numbers app

,
ios number null
,
ios numbers isblank function
,
is null number
,
is there a null value in mac numbers
,
iwork numbers fill blank cells with 0
,
iwork numbers isblank
,
iwork numbers return blank
,
iworks numbers if statement return blank cell
,
mac numbers: how to display zero values as blank
,

nil statements in numbers mac

,
null and not null in numbers for ipad
,

null value in numbers

,
numbers 09 formula blank cells
,

numbers spreadsheet formula detect null