Answered step by step
Verified Expert Solution
Question
1 Approved Answer
problems 7 and 8 I keep getting wrong. I need help with cell D13. I know the formula should be depreciation(D12,D14) and the content should
problems 7 and 8 I keep getting wrong. I need help with cell D13. I know the formula should be depreciation(D12,D14) and the content should be DEPRECIATION but I keep getting the #REF! error in the cell. please help! I've gotten all the other steps correct, just stuck on this.
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) 0.000 Depreciation Value Rate End Function Insert two rows above row 12. Enter the Row heading DEPRECIATION RATE in cell B12, and DEPRECIATION in cell B13 10.0 Use the Depreciation function in cell D13 to calculate depreciation based on the Total Estimated Value on All Items (cell D14) and the Depreciation Rate (D12). 12. Clear the contents in the range B17:K19. ted: 07/25/2017 Current InstStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started