Error validating the formula to pagdating
In this post, I’ll look at a slightly different way of doing this than the exact way I did it in that post.
The are multiple formulas that may work for many of these complex validation requirements, so there isn’t one single correct answer.
Today, we are going to take a step further and talk about the nitty-gritty aspects of custom data validation in Excel as well as experiment with a handful of different validation formulas.
Is there a way to add string at end of the phone validation formula to accept a ‘null’ value to avoid validation error?
To add the testing for the proper characters, we’ll need to wrap the phone number validation formula in an IF() statement and replace the second TRUE result with it. With that formula, our list doesn’t require a phone number to be entered, but if one is entered, it must be in the proper format.