Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Inst

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions