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

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ 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.


Links

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

apple numbers if cell is empty

,

apple numbers null

,

apple numbers null value

,

blank values in numbers iworks

,

how to show null in apple numbers app

,
iwork numbers if cell is empty
,

nil statements in numbers mac

,

null value in numbers

Click on a term to search for related topics.

Tags for this Thread