adds a custom function that will be used in formulas
name | string | the name of a new function, specified in uppercase |
handler | function | the handler function |
$$("ss1").registerMathMethod("NEW", function(value){
// function's logic
});
The handler function can receive a set of parameters you need for your function. For example, you can pass one value (a cell reference) or an array of values (a range of cell values), etc.
You can use the new method as =NEW(H3:H5);