This is a discussion on Numbers formula within the iWork Forum forums, part of the iPad App Store category; 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 ...
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
11-07-2012 10:27 PM
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.
By sgt_hoser in forum Productivity Apps Forum
Last Post: 10-17-2012, 10:04 PM
By Abunaixd in forum iWork Forum
Last Post: 03-06-2012, 04:09 PM
By Zera in forum iWork Forum
Last Post: 09-02-2011, 08:49 PM
By Jmfocus in forum iWork Forum
Last Post: 08-30-2011, 09:06 PM
By Hal05154 in forum iWork Forum
Last Post: 01-23-2011, 03:37 PM
Search tags for this page
formula for figuring percentage difference in iwork
ipad numbers options formula
percentage difference numbers iworks
show formula for percentage in numbers iwork
Click on a term to search for related topics.