Negates the parameter value. When you want to ensure that a value is not equal to a specific value, you can use the NOT function.
Syntax
NOT(logical)
Logical is a logical value or logical expression that can be evaluated to TRUE or FALSE.
Description
If the logical value is FALSE, the function NOT returns TRUE; if the logical value is TRUE, the function NOT returns FALSE.
In life and work, we often need to count multiple data tables. Sometimes we need to check whether the data of the system project meets the conditions. Here, the Not function is involved.
The Not function is a logical function that negates the value of its parameters. It is generally used in combination with the IF function.
Let me show you how to use this function, taking this form as an example;Now you need to filter out those who are younger thanPersonnel aged 18 years old.
■ Position the cursor at D3 and enter the formula =IF(NOT(C3>=18),"Minors cannot enter the game",C3).
If the specified conditions are not met, return the true age; if the conditions are met, return "Minors cannot enter the game";
The return of "18" at this time means that Cao Ying does not meet the conditions. Place the cursor in the lower right corner of D3 and form a cross-shaped drop-down to fill in the formula.
You can determine whether everyone does not meet the conditions.
评论列表(196条)
测试