Formula and Functions

EDITable features an Excel-like formula engine that supports over 50 functions, including logical, boolean, date, math, and others. The formula editor is intuitive and user-friendly and offers dynamic help suggestions regarding syntax and examples. It includes features like auto-complete and multi-line support to better assist users in creating and troubleshooting formulas.

✔️Type the formula in the formula editor while setting up the default values, derived from the data.

✔️ Use formulas while inserting a formula column.

✔️ Enter formulas and operators directly into the table's cells to perform calculations.

✔️ Copy and extend the formulas to the cells below, similar to Excel's 'fill' feature. Please refer to the sections below for a detailed list of the formulas, functions, and operators available for calculations.

• Conditional Statements

• Logical Functions

• Math Functions

• Text Formatting Functions

• Date functions

• Other Operators