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" wrote:

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Chris" wrote in message
...
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