Excel Functions

The ARABIC function in Excel is used to convert a Roman numeral to its corresponding Arabic numeral. Here's how to use it:

1. In a cell, type in the Roman numeral you want to convert.
2. In another cell, type in the formula "
   Formula:

   =ARABIC(cell reference) 

   " where "cell reference" is the reference to the cell containing the Roman numeral.
3. Press Enter and the Arabic numeral will be displayed.

For example, if you want to convert the Roman numeral "XVIII" to its Arabic equivalent, you would type "XVIII" in cell A1 and "" in cell A2. The result in cell A2 would be "18".

The ARPERS function in Excel is used to calculate the depreciation of an asset for a specific period using the arithmetic declining balance method. Here's how to use it:

1. In a cell, type in the initial cost of the asset.
2. In another cell, type in the salvage value of the asset (i.e. the value of the asset at the end of its useful life).
3. In another cell, type in the useful life of the asset (in years).
4. In another cell, type in the period for which you want to calculate the depreciation (in years).
5. In another cell, type in the formula "
   Formula:

   =ARPERS(initial cost, salvage value, useful life, period) 

   " where "initial cost", "salvage value", "useful life", and "period" are the cell references for the values you entered in steps 1-4.
6. Press Enter and the depreciation for the specified period will be displayed.

For example, if you have an asset with an initial cost of $10,000, a salvage value of $1,000, a useful life of 5 years, and you want to calculate the depreciation for the second year, you would type "10000" in cell A1, "1000" in cell A2, "5" in cell A3, and "2" in cell A4. In cell A5, you would type "". The result in cell A5 would be the depreciation for the second year.