IT Questions and Answers :)

Wednesday, November 28, 2018

What is the not equals operator in Excel?

What is the not equals operator in Excel?

  • NOT()
  • <>
  • >=
  • !=

 
What is the not equals operator in Excel?

EXPLANATION

When comparing two pieces of data in Excel, what operator would you use to test if they were not equal?
If I were comparing cells A1 to B1, my formula would be:

=A1___B1
NOT() is a function, not an operator.

SOURCE

https://support.office.com/en-us/article/Calculation-operators-and-precedence-in-Excel-48be406d-4975-4d31-b2b8-7af9e0e2878a#tblID0EABCAFAAA
Share:

Popular Posts