|
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
Percentage Calculation
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 |
| All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com