Before Modelling …
Developing spreadsheets involves is a balancing act between how much you express in formulae within a single cell and how much you break-up formulae across a number of cells. In many cases a single formula captures much of what needs to be computed, but it is so...
Associativity in Mathematics / Arithmetic Operators
This post explains associativity in mathematics / arithmetic operators, with a simple example and visualization. It also shows how it’s easy to make errors if you don’t remember your arithmetic rules (BODMAS).