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
October 2, 2010
Excel IF AND OR Functions Explained
Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and
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