The IF function is probably one of the most used Excel functions because it is easy to understand and very flexible when you apply it to real life situations.

Here I will show you a couple of ways that you can use the IF function to get you up and going.



Helpful Resource:

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Advanced SUMPRODUCT Function: Maximum Sales What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function. Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX fu...
IFERROR Function: Introduction If you have a calculation that results in an error like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, then you can clean it up by using the IFERROR function which allows you to replace the error it with a 0 or a blank cell. I show you both IFERROR examples below. DOWNLOAD ...
Match Two Lists With The MATCH Function I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2. Well I have! With the MATCH function you can verify if a cell´s item in List1 exists in List2. The function will return the r...
Consolidate with 3D Formulas in Excel 3D Formulas or References in Excel are a great way to consolidate data from multiple sheets. 3D Formulas reference several worksheets that have the same structure which allows you to consolidate by using the SUM function. Formula breakdown: SUM(Sheet1:Sheet4!A1) ...