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_test is 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.
---