From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Using the AND and OR functions independently or within IF functions

Using the AND and OR functions independently or within IF functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using the AND and OR functions independently or within IF functions

“

- [Instructor] One of Excel's most powerful functions 2 is the IF function. 3 And it's not uncommon when you use the IF function 4 to also include the functions and, sometimes or. 5 We can also use these functions 6 independently of the IF function. 7 In this worksheet here it's about 600 rows or so. 8 We want to know at a glance 9 which people have exceeded their quota. 10 These are salespersons, let's say exceeded or equal to. 11 And we can simply put over here in column I 12 for the first person here equal, 13 we're checking the actual sales that's in cell D2. 14 Anytime that's greater than 15 or equal to the quota, that's in C2. 16 We'll simply put press enter and there it is, it's true. 17 I'll double click in that lower right hand corner, 18 copy it all the way down the column 19 and we can see easily where it's not true. 20 And of course it pops right out because of this. 21 It might be more effective if we…

Contents