In Excel, the IF function is one of the most popular and useful functions. In this tutorial, we are going to learn the simple formula to test the values, If cells begin with given criteria. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To test the values to see if they begin with one of several characters.
=SUM(COUNTIF(A1,{“x*”,”y*”,”z*”}))>0
Syntax Explanations:
- SUM – The SUM function will help to add values in the cells. Read more on the SUM function.
- COUNTIF – The COUNTIF function helps to count the cells that meet a single condition or criteria.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example image.
- Here, we will enter the input values in Column B. Now we want to check the values that begin with “X”, “Y”, and “Z”.
- Then, apply the above-given formula to the formula bar section.
- Finally, we will get the result in the selected cell.
Conclusion:
Hope you understand how to check the values that begin with the given criteria in Excel. If you have any other ideas or question, do share with us here in the comments section below. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)