1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Numbers formula

Discussion in 'iWork Forum' started by KevinO, Nov 7, 2012.

  1. KevinO
    Offline

    KevinO iPF Noob

    Joined:
    Nov 7, 2012
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Ohio
    Ratings:
    +0 / 0
    I am new to the forum and new to doing spreadsheets. I am trying to do a retirement spreadsheet. I want to calculate a PERCENTAGE DIFFERENCE between 2 numbers. Basically last months balance and this months balance. I would like to find the percentage difference( loss or gain). Can someone help me with the formula . Thanks alot
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,980
    Thanks Received:
    1,843
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,985 / 1
    Format the cell as Percentage by going to the paint brush icon, choosing the Format tab, then Percentage (you can tap the blue arrow for options).

    If you want to know what percentage (more or less) this month's pay (C) is compared to the previous month (P), you would divide the current month by the previous month. C/P = %Change

    P is the amount that you want to reference to. C is the amount that something changed.

    For example (keeping it really simple). If you got paid $100 dollars last month and $50 dollars this month that would be:

    50/100 = .5 = 50% You got paid 50% of the previous month's amount.

    The actual result will be decimal. You could convert the result to percentage by multiplying the results by 100, but using the cell formatting does two things for you.

    One: It formats the result as a percentage.

    Two: It leaves the actually value as decimal, so you can use it in further calculations without having to divide by 100 first.

Share This Page

Search tags for this page

difference formula in ipad numbers

,

formula for figuring percentage difference in iwork

,

percentage difference numbers iworks

,

show formula for percentage in numbers iwork