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; see Text Functions here |
|
IF |
IF |
Similar; see Conditional Functions here |
|
INT |
INT |
Similar; see Number Functions here |
|
LEFT |
LEFT |
Identical; see Text Functions here |
|
LOWER |
LOWER |
Identical; see Text Functions here |
|
MID |
MID |
Identical; see Text Functions here |
|
PROPER |
PROPER |
Identical; see Text Functions here |
|
REPLACE |
REPLACE |
Identical; see Text Functions here |
|
RIGHT |
RIGHT |
Identical; see Text Functions here |
|
ROUND |
ROUND |
Identical; see Number Functions here |
|
SUBSTITUTE |
SUBSTITUTE |
Identical; see Text Functions here |
|
TRIM |
TRIM |
Similar; see Text Functions here |
|
TRUNC |
TRUNC |
Similar; see Number Functions here |
|
UPPER |
UPPER |
Identical; see Text Functions here |