1. ## Percentages (Excel 2002)

Hi

I am always having trouble with percentage formulas.

I would be grateful if someone could fill in the 3 example in the attached spreadsheet.

2. ## Re: Percentages (Excel 2002)

<P ID="edit" class=small>(Edited by sdckapr on 02-Dec-04 16:14. Added to PS)</P>In G4:
=(F4-E4)/E4

Copy G4 to G5:G6.

Format them as Percentage

Change is:
(New -Original) / Original
or
New/Original - 1

Steve
PS:
I am not sure what you mean by "percentage difference".
8 is 32% larger than 6.06
5 is 17% smaller than 6.06 (note value calc is negative)
7 is 16% larger than 6.06

If you really want to calculate the "difference" it is 8-6.06 = 1.94
Also if you really want to calculate the "percentage drop" you should use
=-(F4-E4)/E4
=(E4-F4)/E4

This will give a pos number if the new number is smaller and a negative number if the new number is larger (though I find this dbl negative confusing and prefer to stick with % change)

3. ## Re: Percentages (Excel 2002)

Hi Steve

Thanks for your prompt reply , I think I was confusing difference with increase , what i am trying to do is compare an old cost with a new cost to find how much is has increased or decreased percentage wise .

Thanks

4. ## Re: Percentages (Excel 2002)

Hi Steve

I take your point I will stick with the origional formula that you gave me.

Thanks again

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•