How to use the IF function

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.

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.