View the Project on GitHub handsontable/RuleJS

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) | |||||||||||

4 | AVERAGE(A4:J4): | |||||||||||

5 | SUMIF(A5:J5,'>5') |