谁能帮我解释下下面的公式怎么解释,尤其是后面IF(LEFT(D3,3)="LZW","柳机",""))这个=IF(OR(MID(C3,8,1)="A",MID(C3,8,1)="B",MID(C3,8,1)="K",MID(C3,8,1)="M",MID(C3,8,1)="Q"),"B系列",IF(LEFT(D3,3)="LZW","柳机",""))
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 18:36:11
![谁能帮我解释下下面的公式怎么解释,尤其是后面IF(LEFT(D3,3)=](/uploads/image/z/10137551-23-1.jpg?t=%E8%B0%81%E8%83%BD%E5%B8%AE%E6%88%91%E8%A7%A3%E9%87%8A%E4%B8%8B%E4%B8%8B%E9%9D%A2%E7%9A%84%E5%85%AC%E5%BC%8F%E6%80%8E%E4%B9%88%E8%A7%A3%E9%87%8A%2C%E5%B0%A4%E5%85%B6%E6%98%AF%E5%90%8E%E9%9D%A2IF%28LEFT%28D3%2C3%29%3D%22LZW%22%2C%22%E6%9F%B3%E6%9C%BA%22%2C%22%22%29%29%E8%BF%99%E4%B8%AA%3DIF%28OR%28MID%28C3%2C8%2C1%29%3D%22A%22%2CMID%28C3%2C8%2C1%29%3D%22B%22%2CMID%28C3%2C8%2C1%29%3D%22K%22%2CMID%28C3%2C8%2C1%29%3D%22M%22%2CMID%28C3%2C8%2C1%29%3D%22Q%22%29%2C%22B%E7%B3%BB%E5%88%97%22%2CIF%28LEFT%28D3%2C3%29%3D%22LZW%22%2C%22%E6%9F%B3%E6%9C%BA%22%2C%22%22%29%29)
谁能帮我解释下下面的公式怎么解释,尤其是后面IF(LEFT(D3,3)="LZW","柳机",""))这个=IF(OR(MID(C3,8,1)="A",MID(C3,8,1)="B",MID(C3,8,1)="K",MID(C3,8,1)="M",MID(C3,8,1)="Q"),"B系列",IF(LEFT(D3,3)="LZW","柳机",""))
谁能帮我解释下下面的公式怎么解释,尤其是后面IF(LEFT(D3,3)="LZW","柳机",""))这个
=IF(OR(MID(C3,8,1)="A",MID(C3,8,1)="B",MID(C3,8,1)="K",MID(C3,8,1)="M",MID(C3,8,1)="Q"),"B系列",IF(LEFT(D3,3)="LZW","柳机",""))
谁能帮我解释下下面的公式怎么解释,尤其是后面IF(LEFT(D3,3)="LZW","柳机",""))这个=IF(OR(MID(C3,8,1)="A",MID(C3,8,1)="B",MID(C3,8,1)="K",MID(C3,8,1)="M",MID(C3,8,1)="Q"),"B系列",IF(LEFT(D3,3)="LZW","柳机",""))
这是一个两层IF函数的嵌套.
第一层IF:
判断是否满足条件OR(MID(C3,8,1)="A",MID(C3,8,1)="B",MID(C3,8,1)="K",MID(C3,8,1)="M",MID(C3,8,1)="Q"),也就是说MID(C3,8,1)是否等于"A"或者"B"、"M"、"Q"中的一个.
如果满足条件,就返回"B系列",否则执行第二层IF函数.
第二层IF:
IF(LEFT(D3,3)="LZW","柳机","")
如果不满足上述条件(MID(C3,8,1)=不等于"A"或者"B"、"M"、"Q"中的任何一个),就进一步判断LEFT(D3,3)是否等于"LZW",满足就得到"柳机",如果连这个也不满足就显示空.
这个公式可以简化:
=IF(OR(MID(C3,8,1)={"A","B","K","M","Q"}),"B系列",IF(LEFT(D3,3)="LZW","柳机",""))