Excel Top Tip #10

Never let your spreadsheet go live without first testing your formulas. Make sure you know what results to expect and enter different data sets which will test extremes in the situations you are processing.

Test your formulas

Use sensible test data and check results