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 |