Stand in the current column. Calculates Current minus Previous using the column immediately to the left.
Assist Pro + → Resources → Finance Tools → Accounting Tools → Difference
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsChoose the accounting schedule or source-column range you need to calculate or inspect. On Assist Pro + › Resources › Finance Tools › Accounting Tools, choose Difference to stand in the current column. Calculates Current minus Previous using the column immediately to the left. Compare the calculation or reference to the actual transaction, agreement or applicable guidance.
Comparing financial figures in adjacent periods or columns.
Speeds recurring calculations in financial spreadsheets when you need to calculate Current minus Previous using the column immediately to the left.
Speeds preparing or checking tax, depreciation, lease and ledger calculations by helping calculate Current minus Previous using the column immediately to the left.