How to use the IF function
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
The IF formula, as one of the most commonly used functions, can determine whether a condition is TRUE or FALSE, so as to get one of the two values. In this article, you will see the explanation of IF function, several examples of IF formula, as well as a case demonstration.
· Explanations of IF formula:
IF(logical_test, value_if_true, [value_if_false])
· logical_test (necessary): the condition to be compared
· value_if_true (necessary): the value to be presented as the result when the “logical_test” is TRUE
· value_if_false (unnecessary): the value to be presented as the result when the “logical_test” is FALSE
In a word, the result would be the first value if the logic is TRUE, and the second value when the logic is FALSE.
· Here are some examples.
Formula |
Explanations |
=IF(C3>B3;YES;NO) |
When C3>B3, the result would be “YES”, while it would be “NO” if C3 = |
=IF(C3>B3;B3-C3) |
When C3>B3, the result would be the value of B3-C3. Otherwise, the result would be “FALSE” in the corresponding cell. |
=IF(C2=“Yes”,1,2) |
When the value in C2 is “Yes”, the target cell will present the result “1”, while it would be “2” when C2 is examined being filled with other values. |
Note that if we want to present the result as text contents, quotation marks should be used (e.g. “YES”, “NO”).
· Here is a spreadsheet recording the group sales Performance in January.
Run the IF formula, and we can examine whether or not the groups have reached the monthly goals.
Enter the formula:
=IF(C3>B3;YES;NO)
When C3>B3, the result would be “YES”.Or else, the result would present as “NO”.
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel