excel formulas

We can learn a lot from looking at what others do in Excel, both the good and the not so good. Last week one of my course members asked me to help them understand what a nested IF formula was doing in a file they’d inherited in their new job. It contained 15 nested IF …

Here you'll find a list of common Microsoft Excel formulas and functions explained in plain English, and applied to real life examples. The tutorials are grouped in line with the Function Library so they're easy to find when you need them. And when you're ready to take your skills to the next level check out …

Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and you’ve got yourself a formula that’s much more powerful. In this tutorial we’re going to take a look at the basics of the AND and OR functions and then put them to work with an …

Before the introduction of the IFERROR function in Excel 2007, if you wanted to hide errors displayed by some formulas you had to employ a combination of IF and the ISNA functions, which resulted in Excel having to do the calculation twice. Once to establish whether the result was an error, and again if the result …

SUMIF extends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that meet a certain criteria.  Whilst the SUMIFS function allows you to stipulate multiple criteria, hence the plural. Enter your email address below to download the sample workbook. Get Workbook By submitting your email address you …