From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/shared/03140011.xhp | 72 ++++++++++++++++++++++ 1 file changed, 72 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/shared/03140011.xhp (limited to 'helpcontent2/source/text/sbasic/shared/03140011.xhp') diff --git a/helpcontent2/source/text/sbasic/shared/03140011.xhp b/helpcontent2/source/text/sbasic/shared/03140011.xhp new file mode 100644 index 000000000..6864384ba --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03140011.xhp @@ -0,0 +1,72 @@ + + + + + + + SLN Function [VBA] + /text/sbasic/shared/03140011.xhp + + + + + + +
+ + SLN function + + + +SLN Function [VBA] +Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period. +
+ + + +SLN (Cost as Double, Salvage as Double, Life as Double) + + +Double + +Cost is the initial cost of an asset. +Salvage is the value of an asset at the end of the depreciation. +Life is the depreciation period determining the number of periods in the depreciation of the asset. + + + + +REM ***** BASIC ***** +Option VBASupport 1 +Sub ExampleSLN +REM Calculate the yearly depreciation of an asset that cost $10,000 at +REM the start of year 1, and has a salvage value of $1,000 after 5 years. +Dim y_dep As Double +y_dep = SLN( 10000, 1000, 6 ) +print y_dep ' returns 1500. +End Sub + + +
+SLN function in CALC + +
+ + + -- cgit v1.2.3