Usage of IF function: judge whether a condition is met: if it is met, it will return one value, if it is not met, it will return another value.

Syntax format of IF function: = if (logical _ test, value _ if _ true, value _ if _ false).

Generally speaking, IF is a conditional judgment function: =IF (test condition, result 1, result 2), that is, if the "test condition" is met, the "result 1" is displayed, and if the "test condition" is not met, the "result 2" is displayed.

When writing multi-conditional formulas nested with IF functions, we should pay attention to the following matters:

1. When inputting function content, you need to switch the input method to English format;

2. The expression greater than or equal to is > =;

3. Nested functions are sorted from high to low according to scores.

4. Enter the left parenthesis and the right parenthesis at the same time, so that there will be no problem in the number and level of parentheses, which is also very helpful for learning other functions and forming good habits in the future.