Supported Formulas
RuleX supports 91 Excel formulas. All supported formulas behave identically to Excel 2021.
If a formula in your model is not on this list, the Data Source build will fail with an error. Check the build status and error log in RuleX Admin if your Source does not compile.
| List of formulas | ||||
|---|---|---|---|---|
| ABS | ANCHORARRAY | AND | AREAS | AVERAGE |
| CEILING | CHAR | CLEAN | CODE | COLUMNS |
| CONCATENATE | COUNTA | COUNTBLANK | COUNTIF | COUNTIFS |
| DATE | DATEDIF | DAY | EXACT | EXP |
| FALSE | FILTER | FIND | FLOOR | HLOOKUP |
| HSTACK | IF | IFERROR | IFNA | IFS |
| INDEX | IRR | ISBLANK | ISERR | ISERROR |
| ISLOGICAL | ISNA | ISNONTEXT | ISNUMBER | ISREF |
| ISTEXT | JOIN | LEFT | LEN | LOWER |
| MATCH | MAX | MID | MIN | MONTH |
| NOT | NOW | OFFSET | OR | POWER |
| PRODUCT | PROPER | RAND | RANDBETWEEN | REPLACE |
| REPT | RIGHT | ROUND | ROUNDDOWN | ROUNDUP |
| ROWS | SEARCH | SEQUENCE | SIGN | SQRT |
| SQRTPI | SUBSTITUTE | SUM | SUMIF | SUMSQ |
| SUMX2MY2 | SUMX2PY2 | SUMXMY2 | T | TEXTJOIN |
| TODAY | TRIM | TRUE | UNICHAR | UNICODE |
| UPPER | VLOOKUP | VSTACK | XLOOKUP | XMATCH |
| YEAR |
Need a formula that is not listed? Contact support@coverstack.in.