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