Excel IF AND & OR Functions

hi so in this video we're going to learn about the if function and function and the all function and

how you can use them so let's get started so i'll start with the if functions let's imagine we had

an interview like this one so these are the candidates and these are the scores that they got

and based on this score want to employ them or not so if anyone gets 60 and above they'll be

employed and they get 59 and below they would have failed the interview so in order to do that we're

going to use the if function. So in this one just say equals if. For the logical test we're going to

say this value must be greater than or equal to 60. And if that is the case, if that's true

if this value is greater than or equal to 60, then we're going to say employed. But if this

value is less than 60, we're going to say failed. Enter. And there we have it. Just double click this

one and we can see our results there this one got 59 51 55 52 and all these are below 60 and they

have failed so that's how you can use the if function next we are going to look at the and

function so we're going to use the if function and the and function together so in this case we have

had two interviews so we want our candidates to pass both of these interviews in order to be

employed. So they must get 60 and above in the first interview and they must also get 60 and

above in the second interview. So to do that we're going to use the if function and the and function

together. So in this power say equals if and for the logical test we're going to say and since we

want our two separate interviews to be above 60. So we want this first one to be greater than or

equal to 60 then we also want this second one to be greater than or equal to 60 Okay so once that is done once all of these values are greater than or equal to 60 then we say employed

And if they are less than 60, if any of these values is less than 60 or both of them are less than 60, we're going to say failed

And there we have it. Just double click this one once more. And there we go

So we can see for this one, this value is below 60

This one is above 60. So because one of them is a below schisted that failed, the same is true for these and all of them here

So that's how you can use the AND function. The last one, we're going to use the AND function with the O function

So what we want here is that these candidates should pass one of these interviews

If they pass interview one or interview two, then we'd employ them

If they fail, all of them would not employ them. If they pass, all of them would employ them

So in that case we'll say equals if, so we're going to use the all function

So for the first one we'll say either this must be greater than or equal to 60 or this must be greater than or equal to 60

Okay, if that is true then we're going to say employed. If both of these values are less than 60 we're going to say failed

Enter and there we have it. So this one is employed because one of these values or all of them are above CKST

So double click. There we have it. We can see for these candidates all the values are below CKST

The same is true for this one, this one, and that one. But for other candidates, they just had to pass one interview

Like this one, you can see 55 here is below CKST, but 96 is above CKST

And because of that, they're employed. So it's that easy. that's how you can use the AND, IF and O function. If you like such videos, you can subscribe to the

channel and thank you so much for watching. I'll see you in the next one