Once we are done with the calculation of percentage, depending on this percentage we can determine the result whether it is "First Class" or "Second Class" or "Pass Class" or "Fail
In spreadsheet we can do this kind of logical checking using one of the logical operators "IF".
Information on IF operator:
The operator IF works same as we generally use " if " in regular conversation.
For example:
"If Rohan has Rs. 10 then he will get an orange otherwise he will get a banana."
So in this example first we have to check whether Rohan is having Rs. 10 or not.
If yes then he will get an orange otherwise he will get a banana.
To use IF operator we should have three values, first "test value" second "then value" and third "otherwise value."
We can use one IF operator inside other IF operator also this is called as nested usage of operator. There is no restriction on nested usage of IF operator.
How to use "IF" in spreadsheet to determine the reult:
Firstly we will go to cell "L6" where we want our Result to be displayed
Information on IF operator:
- The operator IF works same as we generally use " if " in regular conversation.
For example:"If Rohan has Rs. 10 then he will get an orange otherwise he will get a banana."
So in this example first we have to check whether Rohan is having Rs. 10 or not.
If yes then he will get an orange otherwise he will get a banana.
How to use "IF" in spreadsheet to determine the reult:
- Firstly we will go to cell "L6" where we want our Result to be displayed
- Now write the formula as
=IF(K6>=60, "First Class", IF(K6>=45, "Second Class", IF(K6>=35, "Pass Class", "Fail"))).- Press "Enter" button.
Here it will test vale given in cell K6 (percentage) for the given conditions.Depending on the test it will give "then value" or "otherwise value"