如何简化我拥有的巨型= OR()语句 [英] How can I simplify a giant =OR() statement that I have

问题描述

多年来，我一直在添加到插入到单元格右侧的函数中，以判断该单元格的字符串是否是个人或公司的名称.现在是一个4页长的google文档.

Over the years I have been adding to a function that is inserted to the right of a cell to tell if the string that cell is the name of a person or company. It is now a 4 page long google document.

结构是此 = OR(ISNUMBER(SEARCH("LLC"，A2))，ISNUMBER(SEARCH("CORPORATION"，A2))，ISNUMBER(SEARCH("COMPANY"，A2))，ISNUMBER(SEARCH("HOLDINGS"，A2))，ISNUMBER(SEARCH("PARTNERS"，A2))，ISNUMBER(SEARCH("EQUITY"，A2))，...)

我尝试用我见过的{Item | Item2 | Item2 | ...}格式列出它们，但是它不起作用.

I've tried listing them in the {Item|Item2|Item2|...} format i've seen but it doesn't work.

如果返回true，则表示它是公司名称.

If true is returned I know it's a company name.

该功能很好用，但是我觉得必须有某种方法可以真正简化它.

The function works great but I feel like there must be some way to really simplify it.

推荐答案

查看是否可行

=REGEXMATCH(A2, "(?i)LLC|CORPORATION|COMPANY|HOLDINGS|PARTNERS|EQUITY")

参考:

• REGEXMATCH

这篇关于如何简化我拥有的巨型= OR()语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！