 Hello friends, welcome to SS Unitech. My name is Sushin Singh and this is continuation of Excel tutorial. So today we want to discuss about if and instead if functions which is a label on Excel. And it's a very important formula. In real time scenario you will face a lot of conditions where if formula will be applied. So let's move to another slide. So this is our slide as you can see here you will understand about the syntax. So if formula takes three parameters first parameter for the condition and second if the condition will be satisfied then we have to specify the value in our second parameter. If condition will not be satisfied then we have to specify the value in our third parameter. So it will be written the output. So what is the agenda for today? So we need to understand about the if then we have to understand about the if with and and then if with or at last we will understand about the the study. So let's start with if. So here you can see we have an input sheet which contains four columns. First is student ID second is to name then mark and then result. So as here you can see result column is blank. So we have to calculate the result by using if formula. So what is the condition for this result if the marks value greater or equals to 300 then we have to specify as a pass. Otherwise it would be fail. So how we can achieve this? Let's move to excel where we will apply the formula to get the output. So this is our status as I have explained we have to specify if then we have to specify our condition in our first parameter. So our condition is this marks value if this marks value is greater or equals to 300 then we have to specify comma and specify the value if this condition will be satisfied then what we want to return we want to return pass. So this is our pass and then we need to again specify the comma and our third parameter if this condition will not be satisfied then we want to display fail. So we have to specify fail over here and then close the bracket and as you can see marks value 250 is less than 300 then it's going to return fail. We can scroll and we can check if the value is greater or equal to 300 then it would be pass. So here we can see 350 is greater than 300 so pass and 450 again pass. So here we can see now we can remove this 430 to 150 and let's check the status value. So here we can see status value has been changed to fail from pass. So I hope you have understand about the if condition. So our second is if with and condition. So here we can see we want to use it but we need to check the first student ID if the student ID is greater or equal to 100 and then we need to again check marks value if the marks value is less or equal to 300 then we want to specify the pass otherwise it would be fail. So here we can see our marks value is 250 so it's less than 300 but student ID is greater than or equal to 100. So in excel sheet we can see student ID is less than 100 so it would be fail and we need to check for the sue where student ID is greater or equal to 100 so it's 107 and if the marks value is less or equal to 300 so it's 200 so it would be pass as other conditions would be fail. So let's move to excel to apply the formula to get the output. So this is our sheet and here we need to apply if then if we want to use and or or condition we have to specify just after if so we have to specify and and then we need to check the student ID if the student ID is greater or equal to 100 and so we have to specify the comma and we can put our second logic. So second logic is marks value should be less or equal to 300 if these two conditions will be satisfied we don't have any other logical condition if we have more than two logical conditions then we can put comma and specify over here if we have more than three then we can specify by using comma and add one by one so here we have only two we have to specify like this and then we need to specify comma if this condition will be satisfied then we want to return as a pass so this is our pass else we need to specify fail and then close the bracket and press enter so it's going to return fail as I have displayed so here force you it's going to return as a pass else it would be fail so I hope you have understood how we can use if condition with and formula as well we have another formula if with or so where we have specify and we can also use or so we need to add one more column result underscore we are going to use or formulas or then if and then we have to specify or and we need to check the student id is greater or equal to 100 and marks value should be less or equal to 300 then we want to specify pass so we need to specify pass and then if this condition will not be satisfied then we need to display as a frame this is our the center as we can see it's going to return pass and these two conditions are failed because the student id value is less than 100 and marks value is again more than 300 so it's going to return fail so I hope you have understand how we can use or formula with if so let's move to another slide for the nested if so this is our nested if condition so here we can see we have to check the marks value if marks value is less than or equal to 250 then it would be fail else if marks value is greater than 250 and less than 450 then it would be pass else we need to specify as a merit in our output so how we can use nested if condition over here so let's move to excel to apply the formula and get the output so here we need to add one more column with nested if this is our nested if and then we need to check if this marks value is less or equal to 250 then we need to specify as a fail so I have to specify over here and then if this value will not be satisfied then we need to again check so we have to specify if then inside if we have to use and condition because we have two conditions if the marks value is greater than 250 and then again we need to check if this marks value is less than 450 so this is our condition if this value will be satisfied then we need to specify as a pass I have to specify over here if these two values will not be satisfied then we need to specify as a merit so this is our merit so we need to close our first if condition and then we again need to close our outer if condition and then pass enter as you can see we have our first value is fail and then pass merit and we are getting the output so in our slide and here both values are same so I hope you have understood how we can use if condition and how we can use if condition with and and or formula and how we can use nested if as well so thank you so much for watching this video if you like this video please subscribe our channel for many more videos and press bell icon to get all the notifications for new updates thank you so much