# RuleJS

View the Project on GitHub handsontable/RuleJS

- Download ZIP File
- Download TAR Ball
- View On GitHub

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

Supported formulas are listed below.

List of supported formulas:

# Demo

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

result:

error:

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