i-nth - 5 ways to double check your Excel formulas

5 ways to double check your Excel formulas

23 February 2017

Here is a simple checklist to double check your Excel formulas work:

Are you mixed up?
Roughly know what your answer should be.
Check the order of precedents or operations.
Switch your view to show formulas.
Ensure all formula arguments are accounted for.

Full article: 5 ways to double check your Excel formulas

Essential reading

Spreadsheet errors: What we know; what we think we can do

Research concludes unanimously that spreadsheet errors are both common and non-trivial. We must seek ways to reduce spreadsheet errors.

Latest articles

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.