Excel icon

A simple formula trick to visualize your errors

Here's a neat trick I use to make spotting worksheet errors very simple.

Wrap your formula in an IF statement that returns the letter "J" if True, or the letter "L" if False, and change the cell's font to Wingdings.

Continue Reading: A simple formula trick to visualize your errors »

Site last updated: February 9, 2012