Numbers formula ??

Discussion in 'iWork Forum' started by rockinamini, Mar 14, 2013.

  1. rockinamini
    Offline

    rockinamini iPF Novice

    Joined:
    Jan 30, 2013
    Messages:
    17
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Fort Worth, Texas
    Ratings:
    +0 / 0
    Hello all. I am new to numbers and this is my need. I have taken a blank spread sheet and on the left side column C I have listed my bills by weeks, on the right side column H my income. I am able to get the sum total of each column at the bottom on line 39. I also want to get the amount left over. I need a formula that will subract C fom H and put it in column G on line 39. Does anyone have any ideas ?

    Mark
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,236
    Thanks Received:
    1,964
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,185 / 1
    It's a pretty simple formula, so I'm guessing your problem is figuring out how to enter it. Here's a step by step.

    • Double tap line 39 in the G column and choose the = sign from the left edge of the editor window to get into formula editor mode.
    • Tap line 39 in the H column. The cell will appear in the editor.
    • Tap the minus symbol in the operators keypad (bottom left of keyboard).
    • Tap line 39 in the C column. The cell will appear.

    That's your formula H39-C39.

    • Tap the green checkmark at the right edge of the editor window to enter and check your formal.


    It should look similar to the screenshot below just before you tap the checkmark, or if you reselect the cell in editor mode (with 39 instead of 10 for each cell's line)

    image-2115608616.jpg

    Good luck.
    • Like Like x 1
  3. rockinamini
    Offline

    rockinamini iPF Novice

    Joined:
    Jan 30, 2013
    Messages:
    17
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Fort Worth, Texas
    Ratings:
    +0 / 0
    twerppoet, thanks for the help it worked as you said, and was very simple. I feel really dumb :(

    Mark
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,236
    Thanks Received:
    1,964
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,185 / 1
    Not a problem.

    Don't feel dumb. Everything looks a lot easier once you know how to do it. :)
    • Like Like x 2
  5. rockinamini
    Offline

    rockinamini iPF Novice

    Joined:
    Jan 30, 2013
    Messages:
    17
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Fort Worth, Texas
    Ratings:
    +0 / 0
    twerppoet,
    Is there a book or any kind of learning resources for numbers ? I need another formula and I hate to keep asking.

    Thanks
    Mark
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,236
    Thanks Received:
    1,964
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,185 / 1
    Here is Apple's iOS App Support page.

    Apple - Support - iOS Apps

    Choosing Numbers and then Getting Started with Numbers will get you here.

    http://help.apple.com/numbers/ipad/1.7/


    This is basically the same information you can find by selecting the wrench icon and Help in the app.

    I have an older book for the iWorks apps, but to be honest it wasn't as clear as Apple's help pages, and didn't cover a whole lot more. At least not the stuff I wanted to know more about. Like you, that was mostly about how to enter and use formulas.

    The only other recommendation I have is to explore. Make a scratch spreadsheet, then explore how to enter formulas. Especially work your way though the various Functions and their descriptions. You don't have to understand how to use them all, but it will give you an idea of what is in the tool box. Then you can concentrate on understanding those that you do want to use.
Similar Threads
  1. Zera
    Replies:
    12
    Views:
    8,403
  2. Jmfocus
    Replies:
    30
    Views:
    8,412
  3. Abunaixd
    Replies:
    16
    Views:
    5,469
  4. KevinO
    Replies:
    1
    Views:
    1,496
  5. vistas24
    Replies:
    6
    Views:
    1,248
Loading...

Share This Page

Search tags for this page

ipad numbers minus sum