Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VARIANCE PERCENT
I'm trying to set up a spreadsheet that calculates a variance percent between
current month and previous month. The percentages work well until I have a a negative balance for current month and previous month, and current month has decreased. I know that its a sign issue, but its making my variance positive and I know thats wrong. Any clues? |
#2
|
|||
|
|||
I assume your current equation is difference divided by last value
try difference divided by the absolute value of last month "Laura" wrote: I'm trying to set up a spreadsheet that calculates a variance percent between current month and previous month. The percentages work well until I have a a negative balance for current month and previous month, and current month has decreased. I know that its a sign issue, but its making my variance positive and I know thats wrong. Any clues? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom percent format needed | Excel Worksheet Functions | |||
Excel % Variance Formula........ | Excel Worksheet Functions | |||
percent formulas | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Variance calculation | Excel Worksheet Functions |