DEC

Syntax

DEC (Number Original Value, Number Amount to Decrement)

Description

The DEC function returns an decremented value based on an original value and the amount to increment.

Returns

An decremented value based on an original value and the amount to increment.

Example

DEC(&NumMonths, &EndMonth - &StartMonth - 1)

This formula subtracts the months between the start and end month to the variable &NumMonths. DEC function is useful in FOR or WHILE functions to decrement loop variables.