楼主 悟空师弟 |
Q:如何判断一个单词是否包含元音字母? A:提供以下两个公式参考:(数组公式)
- =IF(MIN(FIND({"a","e","i","o","u"},LOWER(A2)&"aeiou"))>LEN(A2),"无","有")
- =IF(SUM(LEN(SUBSTITUTE(LOWER(A2),{"a","e","i","o","u"},)))=LEN(A2)*5,"无","有")
详见附件: 如何判断一个单词是否包含元音字母?.rar |
2楼 gouweicao78 |
1、FIND改SEARCH,只多2个字符,而不需用LOWER或UPPER转换大小写。 2、COUNT或ISNUMBER或ISERR+FIND(search)判断包含字母,比&字母+>len或者SUBSTITUTE判断简单。- =IF(COUNT(SEARCH({"A","E","I","O","U"},A2)),"有","无")
- =IF(OR(ISNUMBER(SEARCH({"A","E","I","O","U"},A2))),"有","无")
- =IF(AND(ISERR(SEARCH({"A","E","I","O","U"},A2))),"无","有")
- =IF(AND(ISNA(MATCH("*"&{"a","e","I","o","u"}&"*",A2,0))),"无","有")
- =IF(SUM(COUNTIF(A2,"*"&{"a","e","I","o","u"}&"*")),"有","无")
|