## Need to create a percentage formula

583 Views 20 Replies Latest reply: Jan 31, 2013 8:58 PM by Yellowbox
Previous Next
Calculating status...
Currently Being Moderated
Jan 30, 2013 6:33 PM

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)
• Level 6 (11,825 points)
Currently Being Moderated
Jan 30, 2013 6:49 PM (in response to kaffholter)

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

• Level 6 (11,825 points)
Currently Being Moderated
Jan 30, 2013 7:48 PM (in response to kaffholter)

what is the old number and the new number?

• Level 6 (11,825 points)
Currently Being Moderated
Jan 30, 2013 8:01 PM (in response to kaffholter)

the percent increase is:

(New - Old) / (Old)  = (1500 - 0) / 0 = this is NOT a defined value (as divide by 0 is ilegal)... so I don't know how you get 235.11

Can you describe what you got?

• Level 6 (11,825 points)
Currently Being Moderated
Jan 30, 2013 8:25 PM (in response to kaffholter)

Can you post a screenshot of the table in question?

• Level 7 (28,740 points)
Currently Being Moderated
Jan 31, 2013 1:53 AM (in response to kaffholter)

Hi kat,

"In 2012 the town added a postion and the cost was 1500.00 (b7) This position did not exist in 2011 (c7).  This resulted in a 100% increase to the budget."

Wrong.

An increase from zero budget to a budget of any amount cannot be expressed as a percent increase.

Any increase expressed as a percentage is expressed as a percentage of the starting amount.

Suppose the budget for this position for 2011 was 750.00.

100% of that amount is 750.00.

A 100% increase from the 2011 budget would then be the original budget (750.00) plus 100% of the original budget (750.00), and the new budget would be 1500.00.

But the 2011 budget for this position was 0.00.

100% of nothing is nothing.

A 100% increase is nothing plus nothing.

A 200% increase is nothing plus (nothing x 2).

A 1000% increase is nothing plus (nothing x 10)

"HMMM I am not sure I understand what you mean by "describe what you got"?"

I think a clearer expression would be "show how you got this result (235%). Copy the formula and paste it into your message. show the values that were in each of the cells referenced in the formula." Like Wayne, I'm mystified by this result.

"now that I know that 0 is not a defined value and is illegal."

0 is defined, and has been for centuries. 0 is not illegal. But division by 0 IS 'illegal' in the sense that it is not permitted in mathematics because its result is undefined. Simple example:

I have three halloween treats left in the bowl. Zero ( 0 ) children come to my door calling 'trick or treat.' If I share the treats equally among the children, how many must I give to each child so that I have no treats left over?

"I will just put in 100% in the cell and move on to other things."

Ummm... 'I don't understand this, so I'll just pull a number that 'looks right to me' out of the air, plug it in, and move on." How does putting a wrong value into your budget make the budget turn out right?

" I am going to want this set up like so

b15-c15 goes into cell d15

b16-c16 goes into cell d16"

This works pretty much exactly as you've written it.

In D15, enter: =B15-C15

Grab the Fill control handle (small circle) and drag down two rows to fill the formula into D16 and D17.

Results will appear in each cell as the formula is filled into that cell.

Regards,

Barry

• Level 7 (28,740 points)
Currently Being Moderated
Jan 31, 2013 11:29 AM (in response to kaffholter)

Hi kat,

"However if there was no position for this in 2011.  Then the increase in the budget would be 1500%, right?"

I don't know how to state this any more clearly than what I posted previously:

"Wrong.

"An increase from zero budget to a budget of any amount cannot be expressed as a percent increase.

"Any increase expressed as a percentage is expressed as a percentage of the starting amount."

The position did not exist in 2011, so the budget for the position was nothing.

100% of nothing is nothing.

1500% of nothing is nothing.

7,000,000% of nothing is still nothing.

You are looking for the percentage increase that will make this equation correct:

starting-amount + (starting amount * percentage) = 1500

For a starting amount of 1000, the numbers are:

1000 + (1000 * 50%) = 1500

For a starting amount of 750:

750 + (750 * 100%) = 1500

For a starting amount of 500:

500 + (500 * 200%) = 1500

But your starting amount (the 2011 budget for this position) is 0

0 + (0 * ???%) = 1500

What number can be used in place of ???% that will make that equation correct?

Regards,

Barry

Previous Next

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.