Quote:
Originally Posted by LearningMom
Thank you, that seems to work. The big question is why?
|
I suspect it's because, when the formula saw the 2017 in the IF test, it treated the whole thing as if it was looking for just the number. Replacing the 2017 with ???? causes Word to look at the rest of the expression as well.