NE

The NE function in Google Sheets is used to check if two specified values are not equal. It returns TRUE if the values are not equal and FALSE otherwise. This function is equivalent to using the <> operator.

Function Syntax and Parameters

Syntax: NE(value1, value2)

Parameters:

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

Step-by-Step Tutorial

1. Using NE to compare numbers:

   • Example: =NE(5, 10)
   • Result: TRUE

2. Using NE to compare text values:

   • Example: =NE("apple", "orange")
   • Result: TRUE

3. Using NE to compare cell references:

   • Example: If A1 contains the value 7 and B1 contains the value 7, then =NE(A1, B1) will return FALSE.

Use Cases and Scenarios

1. Data Validation: Check if two input values are not equal.
2. Conditional Formatting: Apply formatting based on whether two cells are not equal.
3. Error Checking: Identify discrepancies between two sets of data.

Related Articles

• How to Compare Values in Google Sheets Using the NE Function
• 10 Useful Google Sheets Formulas for Data Analysis