IT Questions and Answers :)

Monday, March 22, 2021

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:

0 comments:

Post a Comment

Popular Posts