Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • How to get first column number in range in Excel
  • How to get address of last cell in range in Excel
  • How to use Excel MMULT Function
  • How to get last row in numeric data in Excel

Data Analysis Examples

  • Example of COUNTIFS with variable table column in Excel
  • Get column index in Excel Table
  • How to create a Histogram in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • Understanding Pivot Tables in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • Excel Data validation number multiple 100
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain
  • Excel Data validation require unique number

SLN function: Description, Usage, Syntax, Examples and Explanation

by

What is SLN function in Excel?

SLN function is one of Financial functions in Microsoft Excel that returns the straight-line depreciation of an asset for one period.

Syntax of SLN function

SLN(cost, salvage, life)

The SLN function syntax has the following arguments:

  • Cost: The initial cost of the asset.
  • Salvage: The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • Life: The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Example of SLN function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data Description
$30,000 Cost
$7,500 Salvage value
10 Years of useful life
Formula Description Result
=SLN(A2, A3, A4) The depreciation allowance for each year. $2,250

Post navigation

Previous Post:

SYD function: Description, Usage, Syntax, Examples and Explanation

Next Post:

RECEIVED function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to check if cell contains number in Excel
  • How to strip html from text or numbers in Excel
  • How to count specific words in a range in Excel
  • How to split text string at specific character in Excel
  • DBCS function: Description, Usage, Syntax, Examples and Explanation
  • Create date range from two dates in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to get workdays between dates in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates in Excel
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles