If you have an error, try #IFERROR

It is not uncommon to complete a spreadsheet model for expected values only to find that some user inputs¬† are not what you expected result in errors. Depending upon the details, you simply what to stop that error behaviour cropping up in your reporting –...
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....

Spreadsheets through time …

@TimHarford’s article in the @FT shows how spreadsheets are in fact a projection of good practice from when “computers” were just people. The modern risks and issues that have been attributed to “spreadsheet error” fascinating. However...
Understanding JOINTEXT

Understanding JOINTEXT

Normally we use EQUS to demonstrate numeric computations but here is a nice example with textual data. Inspired by some a tweet from @ddalgleish here is a short video showing JOINTEXT visualised using the EQUS add-in https://youtu.be/g7vaSAlwLkI