Alternative to repetitive OR in formula

		Microsoft Office Forums > Microsoft Excel > Excel
Alternative to repetitive OR in formula

FAQ

Thread Tools

Display Modes

07-27-2022, 11:29 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

On fly:

Code:

=IF(ISNA(MATCH(LEFT($B$4,4),{1016,1021,1022},0)),"B","A")

Edit! Are you sure about using OR() in your formula? Or() returns True when at least one expression in it returns True - in your case to get False LEFT($B$4,4) must be equal to 1016, to 1021 and to 2022 concurrently!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to skip repetitive lines to unique entries?	tbdesigns	Mail Merge	1	07-05-2020 11:04 PM
Office 365 repetitive corruption?	markg2	Office	0	10-23-2019 04:18 AM
Creating a Report Template / User Form and/or Content Controls with repetitive data throughout	53bigdog	Word VBA	1	04-05-2016 04:00 PM
automating a repetitive process	vthomeschoolmom	Excel Programming	1	02-28-2012 07:41 PM
repetitive work in word	vishalvijayan	Word	1	03-31-2011 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 AM.