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;...
EXCEL DATABASE FUNCTION

EXCEL DATABASE FUNCTION

Since their introduction in Excel 2007, DataBase functions have remained Overlooked & Underutilised. This is an Introduction in a  Series of articles whose aim is to demystify these Database functions. Database functions include; DSUM, DAVERAGE, DCOUNT, DCOUNTA,...
HLOOKUP, INDEX & MATCH OR VBA

HLOOKUP, INDEX & MATCH OR VBA

Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup. HLOOKUP function is the most popular function for this kind of lookup but it has a number of limitations and thus one may need to know a few other ways you can carry out a...