Apple Event: May 7th at 7 am PT
OK I am trying to create a percentage formula for the following.
B8 is 638.00 and C8 is 731.00 I want the result to tell me what the % is -/+
I am not getting how to create this formula. I am new to this.
Mac Book Pro, Mac OS X (10.5.6)
The percentable of one value to another is the ratio.
B as a percentage of C is B divided by C so...
638 divided by 731 is
638 / 731 = 0.87278
D8=B8/C8
to enter this in a cell select the cell D8 then type "=B8/C8" then enter
If you want the percent increase of one value compared to another:
percent increase of B to C then it would be:
(B-C) / C
to enter in cell D8 type "=(B8-C8)/C8" then hit enter
An increase of any non-zero amount from zero is tecnically undefined as a percentage increase because:
new = 1
old = 0
(new - old) / old -> (1 - 0) / 0 -> 1 / 0 which is undefined. because ANYTHING divided by zero is undefined. Therefore I do not see how you can say the increase is 1500% or any particular number. Can you show the numbers you are using and how?
Wayne, There has got to be a way to show this increase. I am going over the budget and If these new 2012 numbers cannot be incorporated, then the actual percent increase cannot be true.
I added $1 to the old to get a percentage and it is huge. LOL I was thinking the number wuld be 1500% in the one case but it is in actuality 149,500%
Ok never mind, I cannot see the forest for the trees. It does not matter about this one row. In the whole of this department I can use the total in each column to get my percent.
So I have been very helped in all of this.
Thanks
Kat
"It does not matter about this one row. In the whole of this department I can use the total in each column to get my percent."
Correct.
There's no way to calculate or state the increase of a new budget item where the previous cost of that item was non-existent. But the overall increase to the previous year's total budget can be calculated (and the increase to the total budget because of that single new item can be calculated) using the formula supplied by Wayne.
Nice to see an moment when it arrives! 🙂
Regards,
Barry
Hi Kaff,
An Increase of 1500 (or any number) on zero is infinity. Not a good idea to report that your expenditure increased by an infinite amount!
What you **can** report is the % increase in the overall town spending (or the overall spending of that department), partly due to an additional expenditure of 1500 on salary for a Health Officer.
Ian.
Need to create a percentage formula
