What Is IF Function In Excel | Advance Excel

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

What Is IF Function In Excel In Hindi

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.

What Is IF Function In Excel In Hindi


 Condition  : If you get more than 35% then pass or fail

What Is IF Function In Excel In Hindi

Formula : =IF(K2>=35%,"pass","fail")

What Is IF Function In Excel In Hindi

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.

What Is IF Function In Excel In Hindi

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.

What Is IF Function In Excel In Hindi

type formula 
Function =IF(K2>=60%,"1st division",IF(K2>=45%,"2nd division","3rd division"))
What Is IF Function In Excel In Hindi

Similarly take out the rest

What Is IF Function In Excel

#3 Third Example Of If Function In Excel 

another example of IF Function
Function =IF(A2>=90,"Unsafe",IF(A2>=60,"Risky","Safe"))
What Is IF Function In Excel In Hindi


What Is IF Function In Excel In Hindi