listi.net

How to debug or step through a formula in Excel?

To debug a formula in Excel you can use the "Evaluate Formula" Alt+M+V

Most formulas fail due:

Errors in parenthesis

Vlookups not using absolute or column references

Vlookup final param should be 0 for exact match

#N/A in part of a cell being calculated

Use a binary search technique.

Try to break formula to a simpler version and then add back

Try creating temporary calcs in multiple cells rather than one cell

Used named ranges to make the formula more readable

copy formula to text editor and use numbers to identify missing parenthesis.


((adsfasdf)))) (((asdfasdf)))(asdf)))
12        21   123        3211    123