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.