Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Please help me write a formula that calculates the percent change when:
The current result is 11% The prior result is -1.89% I am attempting to compare the current result improvement to the prior result, hence my formula is: (11%--1.89%)/-1.89% (the calculated result is -682.01%) The result should be positive, like 1000% change (improvement), shouldn't it be? Thanks for helping me with this formula. Sony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting negative percent | Excel Worksheet Functions | |||
negative numbers to percent | Excel Discussion (Misc queries) | |||
Problem calculating percent change | Excel Worksheet Functions | |||
Negative percent formula | Excel Worksheet Functions | |||
How do I format a negative percent? | Excel Discussion (Misc queries) |