What is the syntax for GESTEP in Excel?

The syntax for GESTEP is: =GESTEP(number, [step])

What is the DB function in Excel?

DB calculates depreciation using the declining-balance method. It's a financial function that determines how much an asset depreciates over a specific period, useful for accounting and tax calculations.

How is DB different from DDB in Excel?

DB uses the declining-balance method with a specified rate, while DDB (Double Declining Balance) uses double the straight-line rate. DB gives you more control over the depreciation rate.

What parameters does the DB function require?

DB requires: cost (initial value), salvage (end value), life (useful life periods), period (specific period to calculate), and optionally month (months in first year).

Engineering

GESTEP Function in Excel

Tests whether a number is greater than or equal to a step value. Returns 1 if true, 0 otherwise.

Syntax

=GESTEP(number, [step])

Arguments

number (required): Value to test
step (optional): Threshold value (default 0)

Examples

=GESTEP(5, 4) - Test if 5 >= 4 - Result: 1
=GESTEP(3, 4) - Test if 3 >= 4 - Result: 0

GESTEP in technical sheets

Document units in adjacent cells — many engineering functions require exact unit strings.
Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

Only works with numbers

Use cases

Threshold testing
Engineering
Step functions

Frequently asked questions

What is the DB function in Excel? DB calculates depreciation using the declining-balance method. It's a financial function that determines how much an asset depreciates over a specific period, useful for accounting and tax calculations.
How is DB different from DDB in Excel? DB uses the declining-balance method with a specified rate, while DDB (Double Declining Balance) uses double the straight-line rate. DB gives you more control over the depreciation rate.
What parameters does the DB function require? DB requires: cost (initial value), salvage (end value), life (useful life periods), period (specific period to calculate), and optionally month (months in first year).

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.