Custom named variables
When reusable results are not enough, it's handy to use variables.
To declare a variable you need to give it a name and assign a value to that name.
In the example below we assign three variables:
Further we can use them in our calculations:
After assigning value to a variable, it can be used in further calculations.
As with reusable results, changing the variable will trigger changes in all dependent calculations.
Custom named calculations (functions)
If you have a formula that is frequently repeated across calculations, it is convenient to move it to a function, the so-called custom function.
Custom functions are like macros in excel.
In the example below, we created a BMI function.
Here is a detailed usage example: