How to Use DB() in Google Sheets

Description

Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

How To Actually Use DB() in Sheets

DB(cost, salvage, life, period, [month])

Try DB yourself

Use the DB() formula to calculate the depreciation of an asset for the first year. The cost is in cell A1, the salvage value is in cell A2, the useful life in years is in cell A3, and the period is 1. Place your answer in cell B1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for DB(). Click through to watch.

Watch more tutorials

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use...

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

Move Cells to New Row with Formula

Move a range, or a set of cells, to a new area with a simple formula tha...

Beginner

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Add A Timestamp to Task Lists (without Now Formula)

How to add a timestamp to done tasks. Learn how to easily add timestamps...

Advanced

FILTER() NOW()

Unlock these tutorials

Learn more about the DB() formula:

Generate a DB() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DB(). 2 free AI generations, no signup. Members get unlimited use.

Generate a DB() formula