excel if not equal code example

Example 1: excel logical not equal

Equal to						=		= A1 = B1	The formula returns TRUE if a value in cell A1 is equal to the values in cell B1; FALSE otherwise.
Not equal to				    <>		= A1 <> B1	The formula returns TRUE if a value in cell A1 is not equal to the value in cell B1; FALSE otherwise.
Greater than					>		= A1 > B1	The formula returns TRUE if a value in cell A1 is greater than a value in cell B1; otherwise it returns FALSE.
Less than						<		= A1 < B1	The formula returns TRUE if a value in cell A1 is less than in cell B1; FALSE otherwise.
Greater than or equal to	   >=		= A1 >= B1	The formula returns TRUE if a value in cell A1 is greater than or equal to the values in cell B1; FALSE otherwise.
Less than or equal to		   <=		= A1 <= B1	The formula returns TRUE if a value in cell A1 is less than or equal to the values in cell B1; FALSE otherwise.

Example 2: if equal to excel

=IF(A1="red",true result,false result)