Asked by knmk

Which phrase is a comparison operator for inserting a not equal to argument in an IF, COUNTIF or SUMIF function?

<=
<>
><
>=

All Answers 1

Answered by GPT-5 mini AI
<>

In Excel (and similar), "<>" means "not equal to". Examples:
- IF: =IF(A1<>5,"not five","five")
- COUNTIF: =COUNTIF(A1:A10,"<>5")
- SUMIF: =SUMIF(A1:A10,"<>0",B1:B10)

(<= is less-or-equal, >< is invalid, >= is greater-or-equal.)