Excel Function : SLN

Download now!

Excel Function : SLN

Category

Financial

Description

Returns the straight-line depreciation of an asset for one period

Microsoft Excel Reference Page

https://support.office.com/en-us/article/SLN-function-cdb666e5-c1c6-40a7-806a-e695edc2f1c8

Syntax and Description of the SLN Excel Function

and syntax of the RANK.EQ function. The syntax of the RANK.EQ function is as follows: RANK.EQ(number, ref, [order]) The RANK.EQ function has the following arguments: number: The number that you want to rank. ref: An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored. order: A number that specifies how to rank number. If order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Excel ranks number as if ref were a list sorted

About SLN Excel Function

The SLN function returns the straight-line depreciation of an asset for one period. The syntax for the SLN function is: =SLN(cost,salvage,life) cost - The initial cost of the asset salvage - The value of the asset at the end of its life life - The number of periods over which the asset will be depreciated