Ryan
Ryan
Programming language:Whatever
2021-06-30 12:40:19
0
Q:

excel logical not equal

jieun
jieun
Code: Whatever
2021-08-03 03:00:01 
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.
1

Tags

Related

New to Communities?

Join the community