This week's post mostly applies to using the IF function, so if you don't already know how to use this incredibly powerful functi...

I was asked this question in response to an earlier post and thought it was worth sharing my response as it has many applications. The ...

Sometimes the information you need is not in the format you want it in. In Excel, this problem often manifests itself as numbers format...

Just a quick post this week on a quite subtle issue. If I can do a calculation using basic functions, I tend to do that rather than wor...