Select Page

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

## Misunderstanding Percentages … 4*5%

Numerical reasoning is often a challenge, especially when percentages are involved. To start with “%” is very simple, but of course its use in context often makes things harder.  Here we show how putting percentage expressions in Excel and seeing them...

For a short period we are enabling free access to EQUS Expert. This is so you can experience the full functionality of EQUS and put it through its paces. We welcome your feedback on it. EQUS provides an easy to use means of showing how Excel computations are...

## EQUS in action … XOR and IFERROR

@msexcel regularly remind the Excel community of some of the useful functions and formula that help with finance, business analysis, data analysis and all the other jobs that Excel gets used for. Here we’ve a few illustrations inspired by @msexcel. One or the...

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