IF function.Change the result of the formula according to the results of the comparison.(Microsoft Excel)
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.
Contents
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.
---