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

WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).So if you want to find out on what day you were born, then the WEEKDAY function will remind you.DOWNLOAD WORKBOOKHelp...
INDEX-MATCH Maximum Sales The INDEX-MATCH formula cannot only look up values to the left and right of your data but its versatility means that it can also lookup the largest values within an array.Say that you had a list of Sales Reps in one array and their corresponding Sales Values in another array....
Excel Subtotal Function – Avoid Double Count... What does it do?It returns a Subtotal in a list or databaseFormula breakdown:=SUBTOTAL(function_num, ref1)What it means:=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data)***Go to the bottom...
SUMIFS Function: Introduction The SUMIFS function allows you to Sum multiple criteria.For example, you can select one Sales Rep from a list of Sales Reps and select one Region from a list of Regions and return the Sum of those arguments from a Sales list.  See how easy it is...DOWNLOAD WORKBOOK...