IF Function

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:

ArgumentDescription
Logical_testWhat it is you wish to test. The result will be either “True” or “False”.
Value_if_TrueWhat should Excel do if the test returns “True”
Value_if_FalseWhat should Excel do if the test returns “False”

=IF(B2 < C2,”Declining”,”Growing”)

If function dialog box.