The Not Equal function, often represented by the symbol "<>" or "!=" in programming languages like Excel, is a logical operator used to compare two values and determine if they are not equal. It returns a Boolean value of "TRUE" if the values are different and "FALSE" if they are equal.
The Not Equal function is commonly used in conditional statements and formulas to make decisions or perform actions based on whether two values are unequal. It allows you to compare numbers, text strings, dates, or any other type of data.
=NOT(OR(A3="India",A3="USA"))
Let's break down the formula:
The purpose of this formula is to check if the value in cell A3 is neither "India" nor "USA". If the formula returns "TRUE", it means the value in cell A3 is different from "India" and "USA". If it returns "FALSE", it means the value in cell A3 is either "India" or "USA".
Learn All in Tamil © Designed & Developed By Tutor Joes | Privacy Policy | Terms & Conditions