What Is IF Function In Excel In हिंदी |
IF function in Excel This is a very useful function. IF function is used to check the condition. In this, first of all you have to give a condition. And then if that condition is True then the If Function will return one value and if it is False then it will return another value which we have to define while applying the formula.
Syntax
=IF (logical_test, [value_if_true], [value_if_false])
IF Function in Excel Conditional Operators
How To Use IF Function In Excel?
As we just read that IF Function in Excel is used in any type of condition, like we are creating a result in excel and we have to find which students are passed and which students are failed. Using If Function In Excel.
Condition : If you get more than 35% then pass or fail
As you can see in the above image, here we have calculated the result of the students, here is our condition => 35% students whose marks will be equal to or more than 35% will pass and whose marks will be more than 35% If it is less, it will fail. After typing this formula, enter it.
If we see here, the students whose percentage value was less than 35%, those students failed as shown in the image above.
In the same way, if the division of the students is to be declared, then like – if more than 60% then first division, if more than 45% and less than 60% then second division and more than 35% and less than 45% then third division. Can see in the image below.
#2 Second Example Of If Function In Excel
In this method, we have derived the division from students by using If Function.