Expected Results

Table 11-11 Expected Results When Using Variance/Var

Column A Column B Var ([A] , [B])=0 Var ([A] , [B])>0 Var ([A] , [B])<0
Expense Expense 0 Returns a negative value Returns a positive value
Non-Expense Non-Expense 0 Returns a positive value Returns a negative value