Question: Using the provided data set and instructions, please help me find the correct nested IF function to use in Column N . Thank you! You
Using the provided data set and instructions, please help me find the correct nested IF function to use in Column N. Thank you! You should only need Columns D-M in the data table to create the formula.

c. Create a new column (titled Months Depr 2018- this should be in column N.) Using Excel's IF function, calculate the \# of months to depreciate in 2018. HINT: Because you are adopting the nearest month convention it will benefit you to take this one additional step of calculating the number of months in 2018 that you need to depreciate the asset over before you calculate depreciation expense. This will be the most complex formula that we have done yet because we need to consider: - At most, we depreciate 12 months. - At least, we depreciate 0 months (if the asset is fully depreciated). - If asset is less than a year old, we depreciate \# of months since acquisition. - If asset is in its last year, we depreciate \# of months until full depreciation. HINT: Complex situations might require you to use "nested" IF functions. In other works, you might need to insert smaller IF functions within your bigger IF function. HINT: Use "nested" IF functions to calculate \# of months to depreciate in 2018: LOGICAL_TEST: Use the first logical test to identify assets still within their useful life. Cell from "Months Since Acq" column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
