How to use the conditional function if

How to use the conditional function if? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

IF function generally refers to the conditional function in software such as programming or Excel, which judges its "true" [TRUE] and "false" [FALSE] according to the specified conditions, and returns the corresponding content according to the true and false values of logical calculation. You can use the function IF to conditionally check values and formulas.

IF function generally refers to the conditional function in software such as programming or Excel, which judges its "TRUE" and "FALSE" according to the specified conditions, and returns the corresponding content according to the true and false values calculated by logic. You can use the function IF to conditionally check values and formulas.

Grammar

IF (logical_test,value_if_true,value_if_false)

Function

The IF function is a conditional judgment function: if the specified condition evaluates to TRUE,IF, the function returns a value; if the condition evaluates to FALSE, another value is returned.

For example, IF (Test condition, result 1, result 2), that is, "result 1" is displayed if the Test condition is met, and "result 2" is displayed if the Test condition is not met.

Parameters.

(1) Logical_test represents any value or expression that evaluates to TRUE or FALSE. [2]

For example, A10room100 is a logical expression, and if the value in cell A10 equals 100, the expression is TRUE, otherwise it is FALSE. This parameter can use any comparison operator (= (equal to), > (greater than), > = (greater than or equal),