NOT Function (LibreOffice Calc)
The NOT function in LibreOffice Calc reverses a logical value. It returns TRUE when the input is FALSE, and FALSE when the input is TRUE. Learn syntax, examples, common errors, and best practices.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the NOT Function Does ▾
- Reverses a logical value
- Converts TRUE → FALSE
- Converts FALSE → TRUE
- Works with logical expressions, comparisons, and formulas
- Helps simplify complex conditions
- Integrates with IF, AND, OR, and XOR
It is ideal for exclusions, negation logic, validation rules, and simplifying multi‑condition formulas.
Syntax ▾
NOT(logical_value)
;) to separate arguments when multiple are present, but NOT only takes one argument.
Arguments
- logical_value:
Any expression that evaluates to TRUE or FALSE.
Examples:A1 > 10B2 = "Yes"AND(C1 > 0; D1 < 100)
Basic Examples ▾
Reverse a simple logical test
=NOT(A1 > 10)
Returns TRUE when A1 is not greater than 10.
Reverse a text comparison
=NOT(B1 = "Active")
Returns TRUE when B1 is anything other than “Active”.
Reverse a boolean value directly
=NOT(TRUE)
Returns FALSE.
Advanced Examples ▾
NOT inside IF (common pattern)
=IF(NOT(A1 = "Paid"); "Pending"; "Complete")
Returns “Pending” when A1 is not equal to “Paid”.
Exclude a value from a list
=NOT(OR(A1 = "Gold"; A1 = "Platinum"))
TRUE when A1 is neither Gold nor Platinum.
Validate that a cell is not empty
=NOT(A1 = "")
TRUE when A1 contains any value.
Reverse an AND condition
=NOT(AND(A1 > 0; B1 > 0))
TRUE when either A1 or B1 is not greater than zero.
Reverse an OR condition
=NOT(OR(A1 = "Yes"; B1 = "Yes"))
TRUE only when neither A1 nor B1 equals “Yes”.
NOT with calculations
=NOT(SUM(A1:A5) > 100)
TRUE when the sum of A1:A5 is not greater than 100.
Common Errors and Fixes ▾
NOT always returns TRUE
Possible causes:
- The logical test always evaluates to FALSE
- A text comparison includes hidden spaces
- A number is stored as text
Fix:
Convert text to numbers using:
Data → Text to Columns → OK
NOT always returns FALSE
Often caused by:
- The logical test always evaluates to TRUE
- Incorrect comparison operators
- Hidden characters in text values
Err:508 — Missing parenthesis
Occurs when:
- NOT wraps a complex expression missing a closing
) - Commas are used instead of semicolons in nested logic
Err:509 — Missing operator
Occurs when:
- A comparison operator is missing
- A condition is incomplete (e.g.,
A1 >)
Best Practices ▾
- Use NOT to simplify logic instead of writing the opposite condition manually
- Combine NOT with AND or OR for clean exclusion logic
- Avoid double negatives (e.g.,
NOT(A1 <> 10)), which reduce readability - Use helper cells when logic becomes too complex
- Ensure consistent data types (numbers vs text)
Related Patterns and Alternatives ▾
- Use AND when all conditions must be TRUE
- Use OR when any condition may be TRUE
- Use XOR when exactly one condition must be TRUE
- Combine NOT with COUNTIF, MATCH, or VLOOKUP to build exclusion rules
By mastering NOT and its combinations with other logical functions, you can build clean, expressive logic structures in LibreOffice Calc that remain easy to understand and maintain.