View Single Post
 
Old 07-27-2022, 11:29 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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!
Reply With Quote