Fathoming formula

Fathoming formula

Put yourself in the position of a learner … You are following a workbook exercise using Excel. You’ve put the formula in, and entered the data. But something is wrong the number you’ve got is different to the workbook. Option 1: You put your hand up....

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...