Can you please help with this to put an IF formula?

with clear steps

1 Depreciation exercise using built-in formulas 2 3 Remember that you can never depreciate an asset below salvage value. 4 The amount that a company can depreciate is referred to as depreciable cost, and is calculated as cost-salvage value. 5 6 Instructions: Fill in the chart below showing years 1-10 depreciation for straight-line and double declining balance, using Excel built-in function like you did in the previous depreciation project. 7 Make sure that years 2-10 have an IF formula to test that we have not depreciated the asset below salvage value. 8 Save the file as depreciationifyourname and submit as an attachment in the dropbox before going into the team discussion forum, and posting it there also. 9 10 1. Calculate depreciation for years 1-10 for straight-line and double declining balance, as instructed above. 11 2. Calculate accumulated depreciation.. Remember that depreciation expense is the current year's depreciation, 12 whereas accumulated depreciation is all the depreciation taken since day 1 (add this year and all prior years' together). 13 3. Calculate book value.. Remember this is what the asset is worth on our books right now, which we calculate as cost minus accumulated depreciation. 14 4. Now check that your depreciation expense formula has an if in it for years 2-10. The test should be that book value is more than salvage value so that depreciation is allowed. 15 Any year that does not have depreciation, should have a zero in its cell. 16 5. Submit this in the dropbox for me, and then go to the team discussion forum and submit it there also for your team members. 17 6. Work with your teammates debugging all members' files. 18 7. Submit one file in the dropbox for the group that has been debugged and has all participating team members' name on the first page, and your group number in the file name. 19 20 21 Estimated useful life 10 22 Cost 12,000,000 23 Salvage value 2,000,000 24 25 12,000,000 2,000,000 Accumulated Depreciation Book Value 22 Cost 23 Salvage value 24 25 26 Straight-Line Period 27 Depreciation Expense 28 1 29 2 30 3 31 4 32 5 33 6 34 7 35 8 36 9 37 10 38 Double-Declining Value Period Depreciation Expense 39 40 1 41 2 42 3 43 4 44 5 45 6 46 7 47 8 48 9 49 10 Accumulated Depreciation Book Value