Excel Functions

Excel-Style Functions

Connect iPaaS provides a really powerful set of features to apply complex formulas on data for transformation. Here are the set of functions that are available.

Simple Math Operations (+ , - , * , / )

Fig 1. Math Operations

Trigonometry Functions (SIN, TAN, COS etc.)

Fig 2. Trignometry Functions

Date Time Functions (Today, Now() etc.)

Fig 2. Date Time Functions

Statistical Functions (Average, Mean etc.)

Fig 3. Statistical Functions

Text Operations (Clean, Trim, Lowercase etc.)

Fig 4. Text Operations

Data Validation (ISTEXT, ISNUMBER etc.)

Fig 4. Data Validation

Financial Operations (FV, NPV, PV, etc.)

Fig 5. Financial Operations

Logical Operations (OR, NOT etc)

Fig 6. Logical Operations

Engineering Operations (BIN2DEX, HEX2DEC etc.)

Fig 7. Engineering Operations