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

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

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

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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

Rounding should work. Try:

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

Regards,
Fred

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

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"Chris" wrote:

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

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

Fred Smith wrote:
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]
Any help is appreciated.
Chris

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1

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

"Fred Smith" wrote:

Rounding should work. Try:

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

Regards,
Fred

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