Using the if statement do the double declining depreciation method in excel

profilealexpis
dd_balance_1.xlsx

Depreciation Schedule

On the sheet name Depreciation Schedule
Create a Double declining Depreciation Schedule that restricts:
·         Cost: Positive
·         Scrap: less than the cost but not negative
·         Life: restricted to between 2 and 10 years
·         Display: Only years that are equal to or less than life

Sheet1