Welcome to iPadForums.net Guest - Click Here to Register

Numbers app on ipad 2

This is a discussion on Numbers app on ipad 2 within the iWork Forum forums, part of the iPad App Store category; Anyone please help me. I downloaded the NUMBERS APP on my iPad 2. I used the orientation pages and started a new budget page. I ...

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 7 of 7
  1. #1
    iPF Noob
    Member #
    204282
    Join Date
    May 2012
    Posts
    4

    Numbers app on ipad 2

    Anyone please help me. I downloaded the NUMBERS APP on my iPad 2.
    I used the orientation pages and started a new budget page. I have been editing the data to use my own data with no problems however after adding 5 or 6 categories and then adding the data below it will not appear above.
    Meaning when I add data in the bottom table to a category listed in the first let's say 4 category's I edited the data changes and I see the additions above and it shows in the charts with no problem. However after adding the 5 category and so on and so on from that 5th category onwards when I enter the data it will NOT show any addition or data added from the bottom table to the top.
    I know I'm not making any sense but I hope someone else is having the same problems. Please help.

    Thank you

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    Ok, I'm assuming you are using the included Budget template. If you are not , or I've misunderstood what your problem is, give me some more details and I'll take another run at it.

    You probably have to enter the formulas for the new Categories. The template only has the needed formulas on the Category rows already added. To see formulas double tap on the cell, just as you would if you were going to enter data. Here is what the last formula looks like.

    Numbers app on ipad 2-budgetformula.jpg

    The cells below the Other row are empty. They need this formula, appropriately modified. You could try entering it yourself, or you could try copy and paste, then modify the result. Fortunately there is an easier way.

    Tap the cell once and you should get a popup menu. One of the options is Fill. It will surround the cell with a yellow box.

    Numbers app on ipad 2-fill.jpg

    Where you see the double line at the bottom of the box, tap and drag it down until all the cells from the other category are selected. When you release it, the formula will be copied, and better than copied. It will also adjust it so that it refers to the correct cells. If you make a mistake just tap undo and try again.

    You'll have to do the same thing for the Difference column.

  4. #3
    iPF Noob
    Member #
    204282
    Join Date
    May 2012
    Posts
    4
    Thank you so very much. You understood my question perfectly.
    I will follow your guidance,once again thank you.

  5. #4
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    No problem.

    BTW, you'll need to adjust the pie chard as well. Select it, then select Edit References from the popup menu. In the Actual column drag the selection down to include your new categories. Tap the chart again to end the edit. Be careful not to tap any cells, or you'll change the range. Use Undo is necessary.
    Last edited by twerppoet; 05-14-2012 at 08:49 PM.

  6. #5
    iPF Noob
    Member #
    204282
    Join Date
    May 2012
    Posts
    4
    Well your advice was great and very clear thank you so much.
    I am now making budget charts a plenty great restored my faith in the app. You've been a great help cannot say thank you enough.

    Kind regards.

  7. #6
    iPF Noob
    Member #
    204282
    Join Date
    May 2012
    Posts
    4
    Oh one last question. Am I able to DELETE sheets added to my budget template without effecting the data in the budget sheet already entered????
    Any advice would help as I've managed to add multiple sheets but I don't need them :-(.

  8. #7
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    As long as you did not use data from one sheet to compute something on the other, you should be fine. Just tap the sheet's tab and you'll get a popup menu with the delete option.


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. Replies: 1
    Last Post: 02-15-2012, 09:40 PM
  2. Numbers for iPAD
    By b57 in forum iPad General Discussions
    Replies: 3
    Last Post: 12-25-2011, 06:46 PM
  3. Column/Row letters/numbers in Numbers
    By MikeV99 in forum iPad Apps
    Replies: 3
    Last Post: 07-22-2011, 02:10 PM
  4. Ipad Numbers
    By Tfladen in forum iPad FAQ
    Replies: 2
    Last Post: 03-13-2011, 05:36 AM
  5. Numbers for the iPad Demo
    By iDan in forum iWork Forum
    Replies: 4
    Last Post: 05-11-2010, 09:16 PM

Search tags for this page

numbers app

,

numbers app for ipad

,
numbers app for ipad 2
,

numbers app help

,
numbers app ipad 2
,
numbers budget template ipad
,

numbers for ipad 2

,
pages and numbers for ipad 2
Click on a term to search for related topics.