The American Optometric Association suggests that children should have their first regular eye exam at six months of age. Another vision exam should take place when a child is around two or three years of age when their vision undergoes its most rapid development and vision correction is most effective.
The ISNUMBER function is a quick, easy way to check if a cell contains a number. Our example used the IF function to illustrate how ISNUMBER can be used. If you haven't used IF in a formula before, you can read our lesson on the IF function here.
Re: If a cell contains a specific text than return a value Yes. Your formula returned The formula contains an invalid character sequence '-'.. If I change it to =IF(SUM(ISNUMBER(SEARCH(text,A1:A1000)))>0,X,Y) then it returns Operator or expression ':' is not supported in this context.