Expected Results
The following table describes the expected results when using the Variance function with Accounts.
Table B-7 Expected Results when Using the Variance Function
| Column A | Column B | Var ([A] , [B])=0 | Var ([A] , [B])>0 | Var ([A] , [B])<0 |
|---|---|---|---|---|
|
Asset |
Asset |
0 |
Returns a positive value |
Returns a negative value |
|
Liability |
Liability |
0 |
Returns a positive value |
Returns a negative value |
|
Equity |
Equity |
0 |
Returns a positive value |
Returns a negative value |
|
Revenue |
Revenue |
0 |
Returns a positive value |
Returns a negative value |
|
Expense |
Expense |
0 |
Returns a negative value |
Returns a positive value |