Percentage Calculation

C

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
 
C

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.
 
P

pogiman via OfficeKB.com

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

Fred said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top