什么函数可以替代if多条件判断,EXCEL函数IF大于7个条件判定要求还是用IF呢,现有公式,大括号的使用是否正确?有错错在哪里?下面是具体介绍。
我现在是只能计算第一步,即LEFT(D4,2)="20",显示"电",公式的后半部分不再计算,电脑也没有给出其他什么提示,计算结果全部为"0"!
=IF(LEFT(D4,2)={"20","CG","th","jy","ly","fh","gy","YF","QL"},{"电","发","退","借","领","发","供应","应付","应收"},"")
以下为替代方法,多人验证过了:
=INDEX({"电","发","退","借","领","发","供应","应付","应收"},MATCH(LEFT(D4,2),{"20","CG","th","jy","ly","fh","gy","YF","QL"},))
注意大小写是区分的,建议你都用大写。