Named expressions
Name a cell, a range, a constant or a formula, globally or for one sheet, and use the name in any formula.
3 stepsWatch it once, then it is yours: click into the grid at any point to take over.
Type a new discount in the box, or use Discount and VatRate in a formula of your own.
const hf = HyperFormula.buildFromArray(sheet, { licenseKey: 'gpl-v3' });hf.addNamedExpression('Discount', '=10%');hf.addNamedExpression('VatRate', '=23%');// Every net price, C2 to C6: =B2*(1-Discount)// Every gross price, D2 to D6: =C2*(1+VatRate)
Change the discount, and the engine’s answer is timed here.
Make every data point count. Turn millions of them into actionable wisdom.
Let’s make it easier.
Smoother. Faster. All Handsontable.