In the IF function, you can use "" to display blank when the conditions are not met. The example is as follows:

①Function formula =IF (conditional judgment, executed when the condition is true, Executed when the condition is false);

IF(logical_test,value_if_true,value_if_false)

Logical_test repre sents any value or expre ssion whose calculation result is TRUE or FALSE .

For example, A10=100 is a logical expre ssion. If the value in cell A10 is equal to 100, the expre ssion is TRUE, otherwise it is FALSE. This parameter can use any comparison operator (a tag or symbol that specifies the type of calculation performed within an expre ssion. There are mathematical, comparison, logical, and reference operators, etc.).

After calculating the parameters value_if_true and value_if_false, the function IF returns the return value after the corresponding statement is executed.

·If the argument of function IF contains an array (used to create a single formula that produces multiple results or operates on a set of arguments arranged in rows and columns. The array range shares a formula; array constant is a set of constants used as parameters), each element in the array will be evaluated when the IF statement is executed.