I can't seem to get pass this for an hour now to write the Depreication Amount calculation. Seems like a common issue from other students but can't seem to find a straight forward answer in previous posts. Help.

I can't seem to get pass this for an hour now to write the Depreication Amount calculation. Seems like a common issue from other students but can't seem to find a straight forward answer in previous posts. Help.

- 1 person found this helpful
Hi Justin,

There is actually a hint in the In Service column's formula. It's checking whether the "Value>0" I think people try to get too tricky with that Depreciation formula. What you are really looking for is a column in the existing data that has a numeric

*value*already. Then you can just set Depreciation amount equal to that column name.Does that help?

Hi Debbie,

Still no go. I referenced back to the Cost Source exercises, the IF or Lookup I know how to write, but I don't believe there's a formula to bring over the Depreciation amount. I also tried the vlookup for Is Depr.

I am sorry

- 1 person found this helpful
Hi Justin,

Sorry, I think my hint may not have been clear. The column that is meant to be used for Depreciation is already in the data. You don't need to write a formula, or rather your formula is "Depreciation Amount = "this column". Just set Depreciation Amount =Value. We're making the assumption that the only numeric value that's in our data is the one we want to use, because Depreciation must be numeric.

Hi Justin,

There is actually a hint in the In Service column's formula. It's checking whether the "Value>0" I think people try to get too tricky with that Depreciation formula. What you are really looking for is a column in the existing data that has a numeric

valuealready. Then you can just set Depreciation amount equal to that column name.Does that help?