From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 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] There are two logical functions in Excel. 2 One's called and, and one's called or. 3 They're frequently used with the if function, 4 but they can be used in a standalone fashion. 5 In this particular worksheet, there are headings 6 in column H and I, and you can see 7 what we're trying to do here. 8 We simply want to find out if different conditions are true. 9 Now, we might eventually be using an if function here 10 to come up with a bonus amount possibly, 11 but let's first focus on this idea. 12 Did this person exceed his or her sales quota, 13 so we could simply put in the function equal. 14 Is this actual right here, this is the actual sales amount, 15 greater than this amount? 16 It's pretty obvious in this case it's not. 17 So what kind of an answer do we get? 18 False, or of course, in some situations, it'll be true. 19 I'm going to double click to copy this down the column. 20 It's over 600…

Contents