Comparing STEP and Excel Functions

Below is a list of functions available for use within STEP calculated attributes. These functions are either identical or similar to the matched Excel function. Additional data and tutorials are available for these functions in Excel.

STEP Function

Excel Function

Comparison; Additional STEP Documentation

CONCATENATE

CONCAT

Identical; refer to Text Functions

IF

IF

Similar; refer to Conditional Functions

INT

INT

Similar; refer to Number Functions

LEFT

LEFT

Identical; refer to Text Functions

LOWER

LOWER

Identical; refer to Text Functions

MID

MID

Identical; refer to Text Functions

PROPER

PROPER

Identical; refer to Text Functions

REPLACE

REPLACE

Identical; refer to Text Functions

RIGHT

RIGHT

Identical; refer to Text Functions

ROUND

ROUND

Identical; refer to Number Functions

SUBSTITUTE

SUBSTITUTE

Identical; refer to Text Functions

TRIM

TRIM

Similar; refer to Text Functions

TRUNC

TRUNC

Similar; refer to Number Functions

UPPER

UPPER

Identical; refer to Text Functions