I Need help creating a formula, I'm not familiar with the if function, could somebody explain to me how to use it and find the correct formula for this problem?

A B D E F A B C E Amortization Table Double Declining Depreciation Table 1 2 3 4 Loan 5 Rate 6 Term(Year) Payment 7. Period 1 9 2 1 2 3 4 5 6 Value Life $2,000.00 5 7 Year 8 9 3 10 Value at Depreciation Total Depreciation Begin of Year During Year To End of Year 1 $2,000.00 $800.00 $800.00 2 $1,200.00 $480,00 $1,280.00 3 $720.00 $288.00 $1,568.00 4 4 $432.00 $172.80 $1,740.80 5 $259.20 $259,20 $2,000.00 4 $5,000.00 5% 1 Monthly Amount to Amount to Remaining Total interest Payment Interest Principal Balance Payment $428.04 $20.83 $407.20 $4,592.80 $20.83 $428.04 $19.14 $ $408.90 $4,183.90 $39.97 $428.04 $17.43 $410.60 $3,773.29 $57.40 $428.04 $15.72 $412.32 $3,360.98 $73.12 TOY $428.04 $14.00 $414.03 $2,946.94 $87.13 $428.04 $12.28 $415.76 $2,531.18 $99.41 $428.04 $10.55 $417.49 $2,113.69 $109.95 $428.04 $8.81 $419.23 $1,694.46 $118.76 $428.04 $7.06 $420.98 $1,273.49 $125.82 $428.04 $5.31 $422.73 $850.75 $131.13 $428.04 $3.54 $424.49 $426.26 $134.67 $428.04 $1.78 $426.26 $0.00 $136.45 5 11 12 6 7 10 11 12 13 14 15 16 17 18 19 20 13 14 8 9 10 11 12 Part 3: Double Declining Depreciation Table For tax purpose an item may be depreciated over a period of several years N. With the double-declining balance method of depreciation, each year the item depreciates by: value at the beginning of that year * 2/N. For a $2000 value item of 5 years life, the first year's depreciation is calculated as: 2000*2/5. In the last year it is depreciated by its value at the beginning of the last year. Create a double-declining depreciation table as shown below and test your spreadsheet with property value = 2000 and life = 5. Use an IF function to compute each year's depreciation