This logical function in Microsoft Excel returns a “true” or “false” result based on a test condition. For example, you could test if a cell value was greater than a specific number or cell. The function allows you to substitute different labels for True or False, but the words need to be wrapped in quotes. You may also do additional math calculations.
The function takes 3 arguments:
| Argument | Description |
|---|---|
| Logical_test | What it is you wish to test. The result will be either “True” or “False”. |
| Value_if_True | What should Excel do if the test returns “True” |
| Value_if_False | What should Excel do if the test returns “False” |
=IF(B2 < C2,”Declining”,”Growing”)
