Then to test the condition the syntax of the formula becomes, =If(B5=20,E2>=60),”Pass”,”Fail”).
If the score is between 0 to 60, then Grade F.Let’s take an example that met the below-mentioned condition =If(Marks>=40, “Pass”) 2) Nested If Statement If you want to test a condition to get two outcomes then you can use this Excel If statement. Here you can check multiple conditions where you can use Excel If statement. You have to know which of the Excel If you will work at what condition. There are various If statements available in Excel. 4) Excel If Statement with other functionsĮxcel If Statement Multiple Conditions range.How to use If with Or function in Excel.How to apply IF & AND function in Excel.Excel If Statement Multiple Conditions range.
