I. Intro
You can use the NOT function to return the opposite of a logical function, meaning when the result of a condition is TRUE, it returns FALSE, and vice versa.
II. About the function
- Formula: =NOT(logical function)
- Parameters:
- Logical function: Any value or expression that returns a TRUE or FALSE value.
- Example:
- =NOT(A2>=50)
- When the result of cell A2 is less than 50, it will display TRUE; when it is greater than or equals to 50, it will display FALSE.
III. Steps
Use the NOT function
- Select a cell and click Formula in the toolbar, then select Logical > NOT. You can also directly enter =NOT in a cell.
- Enter the parameters in the cell.
- Press Enter to display the result.
- Drag the + icon in the lower-right corner of the cell to apply the formula to more cells as necessary.
250px|700px|reset
Delete the NOT function
Select the cell with the NOT function and press Delete.
IV. Use cases
HR: Use the NOT function to determine bonus eligibility
Calculating bonus eligibility for employees is easy with the NOT function.
- Formula used below: =NOT(C2<20)
- About the parameters: Employees in the following sheet shows qualify for a bonus only if they achieved sales exceeding CNY20,000. Since NOT returns the opposite of a logical function, the opposite condition (sales of less than CNY20,000) should be used to get a list of employees with sales over CNY20,000. TRUE means the employee has earned a bonus and FALSE means they have not.
250px|700px|reset