It would be really helpful if formula drilldown could highlight (maybe bold or with colors) the sections of a formula that actually apply in a specific calculation.
For instance, in formulas with nested IFs, a lot of it will not apply in a particular calculation because the IF condition is not met. However, that is often difficult to tell at a glance. It can be very time consuming to check each condition to determine which one(s) actually apply.
Being able to quickly identify the relevant parts of a formula would make it a lot easier and more efficient to troubleshoot, especially when dealing with very long & complex legacy formulas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.