I need help with a formula that depreciates the value of an item each month until it's value hits $0.00
I have a single table that contains these fields: - Depreciation Start Date (Date Field) i.e. 6/28/2018 - Depreciation Term (Numeric) i.e. 36 months - Item Cost (Currency) i.e. $100 - Monthly Deprecation Value (Currency): Item Cost / Depreciation Term i.e. $2.77 - Remaining Deprecation Value (Formula ? Currency): This is the field that should display the remaining value, and it should stop at $0.