Posted by Johan Vermeire on 17/05/2013.
When you write a complex formula, everything might look logical the moment that you enter the formula, but when you see the formula after a few months, it might look overwhelming. If you receive a workbook from a colleague, it can be very challenging to interpret what he or she wanted to achieve.
In the following three posts, we’ll cover three different ways to analyse your formulas:
- Using the ‘Insert function’ wizard
- Using the built-in ‘Evaluate formula’ functionality
- Using F9