The NE function in Google Sheets is a logical function that allows users to compare two values. If the specified values are not equal, the function returns `TRUE`; otherwise, it returns `FALSE`. This functionality is crucial for creating logical tests in spreadsheets, aiding in data validation and condition-based calculations.

Syntax

NE(value1, value2)

• value1: The first value to compare.
• value2: The second value for comparison.

Example #1

=NE(10, 20)

In this scenario, the function compares the numbers 10 and 20. Since they are not equal, the result will be TRUE.

Example #2

=NE("apple", "apple")

This function compares the strings “apple” and “apple”. Since they are equal, the result will be FALSE.

Example #3

=NE(A1, B1)

Here, the function checks the values in cells A1 and B1. If these values are not equal, the result will be TRUE; if they are equal, it will return FALSE.

Error handling

• VALUE!: This error occurs if either of the values provided is not recognized as valid data for comparison, such as Text vs. Number mismatch.
• N/A: Returned when one or both of the referenced cells are empty or do not contain comparables.

Conclusion

The NE function is a straightforward yet powerful tool in Google Sheets for logical comparisons. By allowing users to verify inequality between values, it enhances data manipulation and analysis. Whether used for filtering data or building complex logical expressions, mastering the NE function can significantly improve spreadsheet functionality.