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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.