The IF logical function will return one value if a condition is true and another value if the condition is false. Use the IF function when you want to compare two items in your workbook. The IF function looks like this:
=IF(logical_test,value_if_true,
value_if_false)
To use the IF Function:
|
|
Logical operators are used to compare numbers in two or more cells to a constant. The logical operators for the IF function are: |
|
To open the Insert Function box, you can also:
|