AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now

NOT function for Sheets

1 min read
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
  1. Select a cell and click Formula in the toolbar, then select Logical > NOT. You can also directly enter =NOT in a cell.
  1. Enter the parameters in the cell.
  1. Press Enter to display the result.
  1. 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
Written by: Lark Help Center
Updated on 2022-10-08
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
rangeDom