gsmith1290Copper ContributorSep 06, 2024not equal in IF formula I can't seem to use a "not equal" symbol (= sign with / through it) in an IF formula.
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.
gsmith1290Copper Contributor to HansVogelaarSep 07, 2024HansVogelaar Thanks, I guess I got too fancy using the special not equal symbol.
