7 ALTERNATIVES TO NESTED IF FUNCTION

7 ALTERNATIVES TO NESTED IF FUNCTION

IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery.  However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond, you can...
EXCEL DSUM FUNCTION

EXCEL DSUM FUNCTION

If you are new to Database Functions, read this Introduction to Database Functions first before you continue. In this article, we shall look into the uses of DSUM function which is one of the EFFICIENT Excel sum functions with criteria. Below are some of its uses;...