Welcome to iPadForums.net Guest - Click Here to Register

Help with numbers!!!

This is a discussion on Help with numbers!!! within the iWork Forum forums, part of the iPad App Store category; I am putting together a spreadsheet using numbers on my very first ipad (2) EVER! I have been using Microsoft FOREVER (first time with a ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14
  1. #1
    iPad Noob!
    Member #
    47156
    Join Date
    Apr 2011
    Location
    Greenville SC
    Posts
    1

    Help with numbers!!!

    I am putting together a spreadsheet using numbers on my very first ipad (2) EVER! I have been using Microsoft FOREVER (first time with a MAC of any kind). This one equation is KILLING ME. Here is what I am trying to do.

    I am a personal trainer and I track peoples weight. So, I have a column of cells that reflects the changes in their weight going from top to bottom. At the very bottom I have a cell that I want to show the "last number in the series of those weigh ins" i.e. each time I add a weight in an empty cell (of the progression) I want it to show up in that bottom cell. If you need a photo image I will be happy to send one. That's all. Very simple. The excel formula is using LOOKUP and a series of symbols and row/cell locations and works perfect. I feel like LOOKUP is what I want but what in the world do I use when all I have to work with is tabs that say "Search for" "search where" and "result-values". PLEASE help! I know there is a formula to do this. Thanks

    Rick
    Last edited by RickH; 04-18-2011 at 07:30 PM.

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    Banged my head against it for a while, but didn't get anywhere. I may try again later when my head stops hurting.

  4. #3
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    Ok, I still don't understand most of how this works, but the OS X version of Numbers has a weight tracking template that does what you want. I exported it to the iPad, and the formula still worked. If you look over the formula they use maybe you can tweak it to work on your spreadsheet.

    Here's a link to download the file: http://dl.dropbox.com/u/17742163/weight.numbers

  5. #4
    iPad Enthusiast!
    Member #
    12114
    Join Date
    Aug 2010
    Posts
    31
    But, to do what you asked, double tap on the cell into which you want to put the formula. A window will open, tap the "=" on the bar above the keys, then tap the "functions" button, then "reference" and you will see Lookup as a function you can use.

    Teach a man to fish, etc, etc, etc.

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    I'm pretty sure the OP knows the function is there. They just couldn't decipher the use instructions. Neither could I. I spent quite a bit of time trying to use the LOOKUP function, but could not make it work as suggested. The formula that works in the Pages example uses different functions in combination with an IF statement. I think I understand it, but haven't looked up all the functions used to make sure.
    Last edited by twerppoet; 04-18-2011 at 09:33 PM.

  7. #6
    iPad Enthusiast!
    Member #
    12114
    Join Date
    Aug 2010
    Posts
    31
    Quote Originally Posted by twerppoet View Post
    I'm pretty sure the OP knows the function is there. They just couldn't decipher the use instructions. Neither could I. I spent quite a bit of time trying to use the LOOKUP function, but could not make it work as suggested. The formula that works in the Pages example uses different functions in combination with an IF statement. I think I understand it, but haven't looked up all the functions used to make sure.
    Perhaps he did know the function is there, but he said, 'all I have to work with is tabs that say "Search for" "search where" and "result-values".' To me that statement shows that he didn't realize a double-tap on the target cell opens up a greater set of choices. If you tap the cell once, that's what you get, you have to tap twice to get to the functions. But in either case, he now has options. It's all good!

  8. #7
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    I thought the same as you, until I looked up the LOOKUP function and realized what he was calling tabs were actualy the names of the parameters for the function, something I probably would not have noticed if I had not got curious and tried to set up a table to use it.

    As you say, no harm, no foul.

  9. #8
    iPad Enthusiast!
    Member #
    12114
    Join Date
    Aug 2010
    Posts
    31
    Quote Originally Posted by twerppoet View Post
    I thought the same as you, until I looked up the LOOKUP function and realized what he was calling tabs were actualy the names of the parameters for the function, something I probably would not have noticed if I had not got curious and tried to set up a table to use it.

    As you say, no harm, no foul.
    Yep, you are right! I got it backwards. My apologies for questioning your inerrant intuition!

  10. #9
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    More like stubborn and pedantic. No apologies necessary.

  11. #10
    iPF Noob
    Member #
    18360
    Join Date
    Oct 2010
    Location
    Denver
    Posts
    5

    Large Spreadsheet test request

    I am looking for someone to test a large (about 12mb) Excel spreadsheet on the Ipad 2 that was too large for the original Ipad. I was considering Docs to Go but really do not care which app.


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

help with numbers

,
how to dl kill 2 in ipad
,

how to insert column in numbers on ipad

,
ipad numbers function reference
,
ipad numbers tutorial formula
,

mac numbers lookup function

,

numb ers tutorial for i-pad

,

numbers ipad tutorial

Click on a term to search for related topics.