View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
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