# 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.

:heavy\_check\_mark:Type the formula in the formula editor while setting up the default values, derived from the data.

:heavy\_check\_mark: Use formulas while inserting a formula column.

:heavy\_check\_mark: Enter formulas and operators directly into the table's cells to perform calculations.

:heavy\_check\_mark: 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