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 eva...
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...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...



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.