Excel Forum
Similar Content
OR Function - Check if Any Argument is True
Tutorial: The OR function in Excel checks if ANY argument in it evaluates to TRUE.  If anything eval...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Introducing Logic into Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce the idea of Logic in Formulas. A Logic test is a ...

Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples

Learn about array syntax with the OR function. See three different ways to check if a Product ID prefix matches our companies three digits prefix. Learn about when Ctrl + Shift + Enter is required for the OR function and when it is not required see that array syntax can be used with the OR function to avoid an array formula that requires Ctrl + Shift = Enter. See OR and LEFT functions.

Got a Question? Ask it Here in the Forum.