Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage calculation | Excel Worksheet Functions | |||
Percentage calculation | Excel Discussion (Misc queries) | |||
percentage calculation | Excel Discussion (Misc queries) | |||
'of' percentage with calculation | Excel Discussion (Misc queries) | |||
Percentage Calculation | Excel Worksheet Functions |