Mar 31, 20181 min readUse SUM OFFSET to model straight line depreciationUse the SUM(), OFFSET() and MIN() functions to dynamically compute straight-line depreciation for capital expenditure in any year. modellingTechnical Resources
Use the SUM(), OFFSET() and MIN() functions to dynamically compute straight-line depreciation for capital expenditure in any year.