To use If and Or statement excel, you need to apply a similar formula as you have applied for If & And with the only difference is that if any of the condition is true then it will show you True. Copy the formula from cell F2 and paste in all other cells from F3 to F13.After you have applied this formula, you will find the result in the column.Add Pass/Fail column in the current table.Then to test the condition the syntax of the formula becomes, =If(B5=20,E2>=60),”Pass”,”Fail”). If the score is between 91 to 100, then Grade A.If the score is between 81 to 90, then Grade B.If the score is between 71 to 80, then Grade C.If the score is between 61 to 70, then Grade D.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |