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