Functions & formulas

FormulasJs

The web applications generated use the JavaScript library Formulajs that implement most of the Excel/LibreOffice functions. Use the box bellow to try some FormulaJs.


Not all of them

Some functions implemented in FormulaJs might not be enabled in Appizy. Please check the listed functions bellow.

Supported functions

List of supported functions after spreadsheet conversion. If your spreadsheet tool uses a function not listed there the web-application might look frozen (the calculations are not running).

Mathematical

SUM, SUMIF, SUMPRODUCT, COS, ACOS, SIN, ASIN, TAN, ATAN, PI, POWER, SQRT, MAX, MIN, AVERAGE, RADIANS, DEGREES, ROUND, CEILING, FLOOR, ROUNDUP, ROUNDDOWN, INT, TRUNC, MROUND, ABS, GCD, LCM, MOD, RAND, RANDBETWEEN, QUOTIENT, PRODUCT

Financial

FV, NPV, PMT

Statistical

FINV, RANK,  STDEV, TDIST, TINV

Logical

AND, FALSE, ISBLANK, IF, IFERROR, IFNA, NOT, OR, TRUE, XOR

Text

CHAR, CODE, CONCATENATE, DOLLAR, EXACT, FIND, LEFT, LEN, LOWER, MID, RIGHT, ROMAN, SUBSTITUTE, TRIM, UNICHAR, UNICODE, UPPER
LOOKUP, COUNTIF

// Not implemented in FormulaJs but provided by Appizy
VLOOKUP

More functions

We test and extend the list of supported function regularly. Do not hesitate to ask if one you need is not yet listed.

Check your web-application accuracy

You must check the output accuracy of your web-application.

Although we are pleased to help you fixing calculation bugs and divergence, we cannot be held responsible for calculation errors in the generated application.