Functions & formulas
Not all of themSome functions implemented in FormulaJs might not be enabled in Appizy. Please check the listed functions bellow.
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).
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
FV, NPV, PMT
FINV, RANK, STDEV, TDIST, TINV
AND, FALSE, ISBLANK, IF, IFERROR, IFNA, NOT, OR, TRUE, XOR
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 functionsWe 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.