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.
GrammarNOT(logical)
Logical is a logical value or logical expression that evaluates 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 parameter. 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 people under the age of 18.
![图片1.png 图片1.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/ab0ad84cf1db13ea03e7bb69221d4dfd.png)
![blob.png blob.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/3592b69993a8f8fe8457be47405e9cd8.png)
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, the real age is returned; if the conditions are met, "Minors cannot enter the game" is returned;
If "18" is returned at this time, it means that Cao Ying does not meet the conditions. Put the cursor in the lower right corner of D3 and pull down the fill formula in a cross shape to determine whether everyone does not meet the conditions.
![图片2.gif 图片2.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/ca3ccb21d6f46938c1b1dba08113e991.gif)
评论列表(196条)
测试