LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 788
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage calculation rpi929 Excel Worksheet Functions 3 July 29th 09 06:58 PM
Percentage calculation mmacnz Excel Discussion (Misc queries) 3 October 22nd 07 05:54 AM
percentage calculation Gabriel Excel Discussion (Misc queries) 1 August 28th 06 09:31 AM
'of' percentage with calculation Steve Crowther Excel Discussion (Misc queries) 2 May 22nd 06 09:58 AM
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"