Popular posts from Glen Feechan's Not Just Numbers blog - The blog for those who know it's not just about the numbers. The content provides useful Excel tips, in easy to understand language. Glen develops spreadsheets for clients all over the world via needaspreadsheet.com as well as through his consultancy work.

Get * The 5 Excel features that you need to know* free, by subscribing to Not Just Numbers

**here**.

## Nested IFs

A tip I have found very useful. Complicated nested IFs are almost impossible to read! However, it is possible to expand the formula bar, break the IF onto more than one line (using Alt/Enter) and indent to make a much more readable statement. The last example of the article becomes:

=IF(A2=0,"NIL",

IF(A2>0,"POSITIVE","NEGATIVE")

)

This one is relatively simple, but when the nesting is 3 or 4 deep it makes a real difference.

Another tip I recommend is where one of the two possible results of the IF is simple and the other more complicated, as above, always express the condition so the simple result is first. Again this makes the statement much easier to unravel when it doesn't seem to be doing quite what you expect!