June 3, 2025
Excel IF AND OR Functions Explained
Excel’s IF function is one of the most powerful tools in your spreadsheet arsenal. Combine it with AND or OR,
Read More
September 22, 2022
Excel IF Formulas and What Not To Do
We can learn a lot from looking at what others do in Excel, both the good and the not so
Read More
May 29, 2013
Excel Formulas
Here you'll find a list of common Microsoft Excel formulas and functions explained in plain English, and applied to real
Read More
September 25, 2010
Excel’s IFERROR Puts an End to Messy Workarounds
Before the introduction of the IFERROR function in Excel 2007, if you wanted to hide errors displayed by some formulas
Read More
September 10, 2010
Excel SUMIF and SUMIFS Formulas Explained
SUMIF extends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that
Read More