gsmith1290Copper ContributorSep 06, 2024not equal in IF formulaI can't seem to use a "not equal" symbol (= sign with / through it) in an IF formula.
2 RepliesReplies sorted by NewestHansVogelaarMVPSep 06, 2024gsmith1290 Excel uses <> for "not equal to". For example: =IF(A1<>B1, "Not Equal", "Equal")gsmith1290Copper Contributor to HansVogelaarSep 07, 2024HansVogelaar Thanks, I guess I got too fancy using the special not equal symbol.
HansVogelaarMVPSep 06, 2024gsmith1290 Excel uses <> for "not equal to". For example: =IF(A1<>B1, "Not Equal", "Equal")
gsmith1290Copper Contributor to HansVogelaarSep 07, 2024HansVogelaar Thanks, I guess I got too fancy using the special not equal symbol.
