excel函数 哪错了=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/08/18 14:38:09
excel函数 哪错了=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000见补充
=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000,IF(AND(C2
=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000,IF(AND(C2
![excel函数 哪错了=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+](/uploads/image/z/5742784-64-4.jpg?t=excel%E5%87%BD%E6%95%B0+%E5%93%AA%E9%94%99%E4%BA%86%3DIF%28AND%28C2%3E20%2COR%28A2%3D%7B2.8%2C3%2C3.1%2C3.15%2C3.2%2C4%7D%29%29%2C%28B2%2B)
公式没写全,应该是=IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000,IF(AND(C2
再问: =IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000,IF(AND(C2
再问: =IF(AND(C2>20,OR(A2={2.8,3,3.1,3.15,3.2,4})),(B2+C2+9)*(C2+D2+6)*2*A2/10000,IF(AND(C2