Excel formula parser
Use our plugin to evaluate Excel formulas and get the result as a number
The plugin takes an Excel formula, like
SUM(1,2,3,4,5)and returns a number and an error code - in the case of the SUM example, they would be 15 and an empty error code.
For a detailed overview of the library the plugin uses, see https://github.com/handsontable/formula-parser.
The plugin takes the Excel formula and converts it into a number, as seen above. There are two ways to get that number:
- 1.Server side action
- 2.Element on the page (client-side action)
The element action is much faster to evaluate, as you don't need to send data to an external server and then wait for a response.
The server side action allows you to use "Result of Step 1's Result" and "Result of Step 1's Error", so you can be sure that you'll always get the right value. If you're running many calculations at the same time or around the same time, you should either use the server side action or place many elements on the page (e.g. using a repeating group) for more reliable execution.
Other examples of Excel functions to test with include:
- PPMT( 5%/12, 1, 60, 50000 )
- IPMT( 5%/12, 1, 60, 50000 )
- CUMIPMT( 5%/12, 60, 50000, 1, 12, 0 )
#DIV/0!Divide by zero error;
#NAME?Not recognised function name or variable name;
#N/AIndicates that a value is not available to a formula;
#NUM!Occurs when formula encounters an invalid number;
#VALUE!Occurs when one of formula arguments is of the wrong type.
If you need the ability to create Excel functions or any other advanced capabilities, or find any bugs in the Bubble implementation, contact [email protected] (or Chris if you're in the AirDev Slack).