Verify Caller Conditional with airSlate SignNow

Make up conditional field statement of work

hi everybody this is Eugene O'Loughlin lecture in computing at the National College of Ireland and welcome to my series of short how-to videos in this video we're going to learn how to use basic conditional formatting with an if statement in Excel 2010 so let's see first of all take a look at what we want to achieve economy here I've got a list of students in this case just by letter to anonymize the data in column B I've got the grade they achieved on an assignment in percentage and then in column C I've got two indications as to how well the TAS has done each cell and represents tells me whether the student has passed or failed the pass mark in this test was 40 percent so any value 40 percent or over will have the word pass inserted here and any value less than 40 will be have the word fail inserted here but I also want to have color to represent this as well so in other words any pass I want the cell to be filled in green any fail I want a cell to be filled with red so I've got a nice visual representation of how well my class did here in addition to telling me whether I've passed or fail I've also got a colors here and we can see here very quickly three students have failed this particular assignment not so easy to see this true column B so let's go and see how we create this so we my worksheet here I've got in column a my students by letter again in column B I've got the same grades that they've achieved in the assignment and I'd like to first of all get the insert the words pass or fail to indicate whether a student is passed or fail in column C and the syntax for an if statement let's remind ourselves of that it's in the brown box over here on the right hand side which I have been equals if and then there are three parts to the statement the first part is a logical test the second part is what we do if the value is true of that logical test and the third part is what we do if the value is false by way of example here well we want to test whether the value is a pass value or a fail value so we say if and we want to use cell b2 here's our first example is less than 40 well then if that statement is true well then and the student has failed but if the statement is false they will have passed so if it's true we insert the word fail in the cell if it's false we insert the word and pass so let's go ahead and put add this into our spreadsheet first so I'm going to click on cell c2 over here typing equals the word...