When combining (or nesting) the AND function with the IF function, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself.

So you can show the results of Sales Reps that have made more than $3,000 of sales AND who are part of the North region, as explained below…

DOWNLOAD WORKBOOK

If_And

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Evaluate Formulas Step By Step in Excel This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones!Excel provides the way to evaluate your formula, and break it down step by step so that you can understand it! ...
Return the Last Value in a Column with the Offset ... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
Vlookup Approximate Match in Excel What does it do?Searches for an approximate value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.Formula breakdown:=VLOOKUP(lookup_value, table_array, col_index_num, )Wha...
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 ...