1 Reply Latest reply: Feb 19, 2013 10:21 AM by Jerrold Green1
Dave AK Level 1 Level 1 (0 points)

How do you add like 5% to a list of numbers?

Numbers, Mac OS X (10.7.5)
  • Jerrold Green1 Level 7 Level 7 (29,955 points)

    Hi Dave,


    Numbers doesn't have the feature that you might be familiar with in Excel that allows you to do an operation on a column in that manner. The way to do it in Numbers is just basic:


    Let's say that your original data is in Column A. In an auxiliary column, write:


    =A+ A*5%


    (or =A*(1+5%)


    (or =A*1.05)


    Then Copy or Fill this expression to the rest of the auxiliary column. Copy the Auxiliary column, Edit > Paste Values over Column A.


    This Auxiliary column can be any blank existing or inserted column.