View the Project on GitHub handsontable/RuleJS

JS Library to parse excel formulas (based on jison parser and formula).

Supported formulas are listed below.

List of supported formulas:


Try to parse the formula by typing ex. AND(1,0) into input below and press Parse button.

Try to insert formula into input field by typing ex. =A1. It's possible to edit formula by double clicked on input field.

A B C D E F G H I J fn(x)
1 SUM(A1:D1, H1)
2 MAX(A2:J2)
3 MIN(A3:J3)
5 SUMIF(A5:J5,'>5')