An own function for formulas. It gets the evaluated arguments (never an error – an error argument is returned without calling the function) and returns a number, text, boolean or null. Anything else, an exception or NaN becomes #VALUE! resp. #NUM!.
null
NaN
#VALUE!
#NUM!
Rest
const VAT: FormulaFunction = (net) => Number(net) * 0.19;compileFormula("VAT([price])", { functions: { VAT } }); Copy
const VAT: FormulaFunction = (net) => Number(net) * 0.19;compileFormula("VAT([price])", { functions: { VAT } });
1.1.95
An own function for formulas. It gets the evaluated arguments (never an error – an error argument is returned without calling the function) and returns a number, text, boolean or
null. Anything else, an exception orNaNbecomes#VALUE!resp.#NUM!.