The IF function is a function that changes the result according to a condition.
Together with the XLOOKUP and VLOOKUP functions, it is a function that expands the use of Excel.
How it works
=IF(logical_test,value_if_true,value_if_false)
| Name | Omission | Explanation |
|---|---|---|
| logical_test | Required argument. | Conditional expression. |
| value_if_true | Required argument. | Result if logical_test is TRUE. Both value and formula can be specified. |
| value_if_false | Required argument. | Result if logical_testis FALSE. Both value and formula can be specified. |
Demonstrate
Use comparison operators to create conditional expressions.
Enter the score for each examinee and it will indicate whether the test taker passed or failed.
Spill
If you specify the argument "logical_test" the cell range, it will be Spil.
---