Percentage Calculation

[Chris]

I am trying to calculate the difference between two percentages but it's
using the full decimal which is not the result I need. For example, I have
77% and 76%. I want the result to be 1% but because it is using the full
decimals (77%= 77.270) and (76%=75.639) it's calculating 2%. The calculation
is correct, but how can I create the formula so it comes out as 1%? I tried
rounding up/down, but not working.
Any help is appreciated.
Chris

 

[Ashish Mathur]

Hi,

Try this

=INT((C10-C11)*100)/100

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Chris]

thank you- It worked on that one, but there are others that it did not work.
Wondering if there one formula that would work on all. The other one is
(73%)72.640 - (80%)80.336 which comes up 8 with that formula. Thanks again.

 

[Ashish Mathur]

Hi,

Try this

=ROUNDDOWN((D7-E7)*100,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Fred Smith]

Rounding should work. Try:

=round(c11,2)-round(c10,2)

Regards,
Fred

 

[Jacob Skaria]

Try

=FLOOR(C10-C11,0.01)
and format to %

If this post helps click Yes

 

[pogiman via OfficeKB.com]

This would be my answer since the displayed figure usually follow simple
rounding.

Rounding should work. Try:

=round(c11,2)-round(c10,2)

Regards,
Fred

thank you- It worked on that one, but there are others that it did not
work.

[quoted text clipped - 21 lines]

 

[Chris]

Thanks to all. Just what I was looking for. Chris