Welcome to iPadForums.net Guest - Click Here to Register

Null value with Numbers

This is a discussion on Null value with Numbers within the iPad General Discussions forums, part of the Apple iPad Discussions category; 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 ...

Register with iPad Forums
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    iPad Noob!
    Member #
    52618
    Join Date
    May 2011
    Location
    Redmond, wa
    Posts
    2

    Null value with Numbers

    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. Ads


  3. #2
    iPF Novice
    Member #
    5416
    Join Date
    May 2010
    Posts
    12
    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)

  4. #3
    iPad Noob!
    Member #
    52618
    Join Date
    May 2011
    Location
    Redmond, wa
    Posts
    2
    That did it. Double quotes. Thank you. Numbers is actually pretty powerful, if you just know the tricks.


Advertisements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Numbers app
    By robertmorgan480 in forum iPad Apps
    Replies: 1
    Last Post: 03-20-2011, 04:24 PM
  2. Numbers
    By jimdd in forum iPad Apps
    Replies: 1
    Last Post: 02-07-2011, 01:18 AM
  3. New to numbers
    By Blarto35 in forum iWork Forum
    Replies: 0
    Last Post: 10-17-2010, 10:59 PM
  4. Numbers
    By Sincere11105 in forum iWork Forum
    Replies: 5
    Last Post: 08-21-2010, 08:06 AM
  5. Only certain numbers
    By poshpantspaddy in forum iWork Forum
    Replies: 0
    Last Post: 07-04-2010, 04:01 PM

Search tags for this page

advanced spreadsheet formula blank cell apple numbers
,
advanced spreadsheet formulas blank cell ipad numbers
,

apple numbers function if blank

,

apple numbers null value

,
compare null number value
,
mac numbers empty value
,

null value in numbers

,

number null

,
numbers isblank
,
numbers iwork emty as zero
,

numbers return blank cell

,
what is null number?
Click on a term to search for related topics.

Tags for this Thread