Can Excel recognize multiple numbers within a cell in regards to formulas? I can use the "IF" formula to tell Excel that if there is a number 1 in A1, to place an "X" in B1 and if there is a number 2 in A1, place an "X" in C1. How do I get Excel to recognize both a 1 AND a 2 in A1 so that B1 AND C1 both get "X"'s? Is this possible?