# Excel-like formula editor

Inforiver provides a no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers. The formula editor provides syntax, examples and features such as autocomplete, multi-line support and more to help users create, and troubleshoot formulas.

(a) Conditional statements - IF, IFNA and SWITCH

(b) Logical functions - AND, NOT, OR, IN, ISEMPTY etc. 

(c) Math functions - ABS, AVERAGE, AVERAGEIF, COUNT, SUM, FILTER etc. 

(d) Text formatting functions - CONCATENATE, LEFT, RIGHT, MID, CLEAN, UPPER, LOWER etc. 

(e) Date functions - DAY, MONTH, DATEADD, DATEDIFF, FROMEXCELDATE, TOEXCELDATE etc.

(f) Statistical functions - MEDIAN, MODE, QUARTILE, QUARTILEEXC, STDEV, STDEVP etc.

(g) Sort functions – SORT, SORTDESC

(h) Identifiers - COLUMNS, DESCENDANTS, HAS, HAS\_ALL, RELATIVE etc.

{% embed url="<https://lumel.wistia.com/medias/a0mfli8yqa>" %}

> ## **Related resources**
>
> #### Feature highlights
>
> [Visual calculations in Power BI](https://inforiver.com/webinars/visual-level-formula-calculations-powerbi/)
>
> #### User guide
>
> [Insert calculated rows](https://docs.inforiver.com/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-rows)
>
> [Insert calculated columns](https://docs.inforiver.com/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-columns)
>
> [List of formulas and functions](https://docs.inforiver.com/formula-syntax)
>
> #### Blog
>
> [Excel-like MoM, QoQ, YoY % calculations in rows in Power BI](https://inforiver.com/blog/general/excel-like-mom-qoq-yoy-calculations-power-bi/)
>
> [Insert calculated measure or column in Power BI](https://inforiver.com/blog/feature-highlights/insert-visual-measure-column-calculations-in-microsoft-power-bi/)