Numbers Question - Column formula

Discussion in 'iWork Forum' started by donka, Jun 29, 2012.

  1. donka

    donka iPad Junkie

    Joined:
    Sep 21, 2010
    Messages:
    796
    Thanks Received:
    26
    Trophy Points:
    28
    Location:
    Scotland
    Ratings:
    +27 / 0
    Hi,

    I am new to Numbers on the iPad but really enjoying it for my non demanding needs. I have one question about making a full column adhere to a formula e.g.

    Column Buy & Column Sell. I want a third column that will show the profit i.e. Column Profit.

    Now I can achieve this by entering a formula as A3 = A2-A1 i.e. Profit(A3) = Sell(A2) - Buy(A1). Now if I copy this cell then double tap the column for Profit to highlight all the data cells in this column and hit paste I can choose to paste in the formula. Now for all subsequent rows, the Profit column will calculate based on what is entered in the Buy & Sell for that row. This works fine.
    The issue is if I add a new row, I then need to paste in the formula so that it will calculate the profit for any new rows. What I want to know is, is there a way to tell Numbers that the column Profit will always use that formula for any new rows added instead of having to paste in that formula again? I guess I am trying to set a formula for the entire column and not just for specific cells.
     
  2. pilgrimav8r

    pilgrimav8r iPad Fan

    Joined:
    May 31, 2012
    Messages:
    116
    Thanks Received:
    12
    Trophy Points:
    18
    Location:
    UK
    Ratings:
    +17 / 0
    I'm certainly no expert on this but I use it quite a lot and its easy to do in excel but I reckon if you are simply adding another row; provided the column is formatted to whatever formula you have it will continue for as many rows as you want to add. Sadly all the iWork's apps for the iPad just lack what I think are fundamental in their use, it's such a shame. I just tried to format the row and it works!

    SP
     
  3. donka

    donka iPad Junkie

    Joined:
    Sep 21, 2010
    Messages:
    796
    Thanks Received:
    26
    Trophy Points:
    28
    Location:
    Scotland
    Ratings:
    +27 / 0
    I can't see any way of adding a formula to a column though, I can select all the cells in the column and paste the formula to them but any subsequent rows you add will not have this formula unless you add it manually to these new rows. Setting the format of a column can be done i.e. setting to date, or currency etc. and any new rows added will have this formatting but not with a formula.
     
  4. tomcorbett28

    tomcorbett28 iPF Novice

    Joined:
    Nov 15, 2011
    Messages:
    36
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I don't think I'm doing this correctly. But I'm trying to get some good instructions on how numbers formulas work in numbers on the iPad 2. Excel I have been or king with for years and I see no problem at all. But Numbers is another ball age. I thought it was going to be so easy because Excel is very easy for me now.

    Thanks for your help.
    Tom
     
  5. Moray

    Moray iPF Novice

    Joined:
    Jan 27, 2012
    Messages:
    31
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    France
    Ratings:
    +1 / 0
    Try looking at the excellent book by Gary Rosenzweig, "My iPad. 4th edition". 2012, by Pearson Educational, and quepublishing.com, pages 248-250. I think you will find the answer, which includes using Footers and New Form. . He has explicitly a bright red warning about how to make a function copy itself when you add rows to an existing table.

    Hope this helps..
     
  6. donka

    donka iPad Junkie

    Joined:
    Sep 21, 2010
    Messages:
    796
    Thanks Received:
    26
    Trophy Points:
    28
    Location:
    Scotland
    Ratings:
    +27 / 0
    Is there any chance of you sharing that information here?

    Sent from my iPad using iPF
     
Similar Threads
  1. Zera
    Replies:
    12
    Views:
    8,656
  2. Jmfocus
    Replies:
    30
    Views:
    8,928
  3. Abunaixd
    Replies:
    16
    Views:
    5,717
  4. KevinO
    Replies:
    1
    Views:
    1,629
  5. rockinamini
    Replies:
    5
    Views:
    1,707
Loading...

Share This Page

Search tags for this page
apple numbers formulas for all column
,
apply a formula to an entire column in mac numbers
,
how to copy formula in whole column iwork numbers
,
iwork numbers apply function to column
,

iwork numbers column formula

,
iwork numbers column function
,
iwork numbers paste column
,
numbers column formula
,

numbers ios how to apply a formula to an entire column in

,
preserve column and row numbers iwork function