Quick tip: Make your formulas legible

Embedded Excel functions is certainly a great feature, but it often makes formulas really long and hard to read.

You can easily make your formulas more legible by simply pressing ALT-ENTER while editing it to force a line feed. See for yourself the result of doing so.

Note that you need to put the line feed (ALT-ENTER) after the comma or else Excel won’t accept it, the notable exception being when the comma is in a text string, as in the next picture.