From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Use AND/OR functions

Use AND/OR functions

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Use AND/OR functions

“

- [Instructor] What if you were given the task to determine which of the sales reps in your company met one, all or none of the sales goals? Well, you would use the AND function to see if the sales rep met all of the criteria, the OR function to see if the sales rep met at least one set of the criteria, and you would use the NOT function to see if they met any of the criteria. In this video, we'll review the AND, OR and NOT functions so you'll be prepared to quickly complete any task on the MOS exam when you're asked to use these logical functions. I have the 04_01 exercise file open so let's take a look at our bonus info worksheet and see if we can determine if we have gold producers, silver producers or rookies. Let's start off by taking a quick look to see if the sales rep met the sales goal. We're going to take a look at their sales in column B and see if they met the sales goal of $500,000. We're going to use a simple if statement and it looks like this, =IF B10 is greater than…

Contents