Reference | Using formulas#
Excel provides the ability to create complex formulas for computing new values based on arbitrary selections of cells.
![../../_images/excel-formula.png](../../_images/excel-formula.png)
Dataiku’s approach to tabular data is similar to Excel’s structured references to columns. Instead of referring to cells within a table, Dataiku formulas refer to column names, and the formula is applied to each row in the table. Formulas are provided as a step in Dataiku’s Prepare recipe, along with an expression editor to validate your formula. The expression editor shows a preview of results of your formula, examples of correct syntax, and a reference guide to functions you can use in formulas.
See also
More information can be found in the Formula language page of the reference documentation.