Sunday 7 March 2010

Mind the Brackets: Coding Formulas in Excel

When coding formulas in Excel (using VBA or an Excel worksheet function) make really really sure that brackets are in the right place. Wrongly grouping expressions leads to erroneous results!!! Know your formulas inside out. Practise the calculations thoroughly with a calculator first if possible. Cultivate the ability to spot bugs in formulas quickly!!!

No comments: