Using the if statement do the double declining depreciation method in excel
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 | ||