Create Mark Validated with airSlate SignNow

Validate Sign PPT Free

in this tutorial I'm going to show you a way to create complex data validation checks in Excel so that you can make sure the users of your file who are inputting data in your template that they don't make any mistakes especially if you need to make sure that they input the correct combination of text and numbers in a Cell so in the previous video we covered the basics of excels data validation if you miss that I'm gonna put the link to it below the video but what if we have more complex cases [Music] to get a hang of how excels custom data validation works let's try and solve for these three cases in the first case we want to create a data validation right here where the user can input company code but we have to check that the first character is any text followed by four digits how do we do this check we can use a formula for it so if we go to data validation right here under in the data tab on data validation we can select custom and we can input our formula right here but I'm not going to do that I'm actually going to input my formula in the cells right here because when it inputted in the cells I get Excel help with my arguments right so whenever you're dealing with more complex formulas it's always easiest to write it in the cell first and then once you're happy with it copy and paste it in here okay so let's go back and think about our formula we need to do a few checks here what are those checks well one check is that we need to make sure that the total number of characters equals five gray so that's one check so I'm just gonna write them here and we can do each single check separately and then we can combine them into one check what's the formula for this one well we can use the Len function right that gives us the number of characters into text we're gonna have our data validation here so I'm just going to click on this close bracket press enter so now let's just put in some dummy text here so I'm going to put C 2 3 4 5 ok so total number of characters is 5 ultimately I want these to result in true and false values so I'm actually going to write out the test here blend a 5 equals 5 okay in this case it's true if I delete any of these numbers it's going to revert to false okay what's the second test let's do the numbers first we want to check that the last four characters are numbers which also means that the combination of these four numbers must be a number which formula can they use to strip out the last four characters I can use the right function I just have...