IF Function | IF Function in Excel | Microsoft Office training

IF Function | IF Function in Excel | Microsoft Office training

The topic of the day is How to use IF Function on Excel, IF Function is One of the most important and most useful function of Excel which is mostly use in nowadays in all kind of Office Work. With the help of IF Function we can do a lot of Work, For Example Find the Grade of a student, Pass or Fail, Good or Bad, Expensive or inexpensive etc. So today we will work on a student result that how we can find the Grade of a student. To find the Grade of a student, Follow the steps which are given below.

• Start Microsoft Excel 2007
• Create a datasheet as given below as i teach you in my previous tutorial.

 

• Now click on the first cell of Grade as given above and type the below function.
• =IF(G4>700,"A",IF(G4>600,"B",IF(G4>500,"C","Fail)))

•  Now i going to Explain the part of If function, When we type IF function in excel the three value will appear which are "Logical_test","Value_if_true" and "Value_If_False" so now i will explain it that what are these value, Number First value is "Logical_test", Logical test is a expression which either evaluates TRUE or False , and number second value is "Value_if_false", which is after "Logical_test" value, which means that if your types logical_test value become right so what should be do, and our answer is which is in this function ,"A", its means that if our typed function become right so give it Grade "A", and after "A" we again use IF Function because now we want to find Grade "B" value so for this we type 600 replace of 700 and type B replace of A, its means that if our value become equal or more than 600 so give it Grade "B", after that again this function for to find the value of Grade "C" and our third value become finish which is "C", after C we use a comma, after a comma our third value will be asked which is "Value_if_false", Value_if_false means that if a value become less than 500 which is our typed value for Grade "C" so what should be do and our answer is "Fail". The complete and summary of the explanation of function is " If our typed value which is G4>700 become right so give it Grade "A", B and C also like this, After C we will use a comma, after a comma our third value will become highlight which means that if you type value become less than 500 so give it "Fail".
• Now drag the cursor below as given below.

 This is our IF Function, i know to use it in more than 5 methods but if i teach it so it will become boring, therefor i teach it only one method. I hope you all like it

Posted in: Microsoft Excel