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)
  • 1. Re: adding a percentage in a number
    Jerrold Green1 Level 7 Level 7 (28,990 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.

     

    Jerry