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
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/12 05:51:59
![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](/uploads/image/z/2679635-11-5.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%2BC2%2B9%29%2A%28C2%2BD2%2B6%29%2A2%2AA2%2F10000%E8%A7%81%E8%A1%A5%E5%85%85%3DIF%28AND%28C2%3E20%2COR%28A2%3D%7B2.8%2C3%2C3.1%2C3.15%2C3.2%2C4%7D%29%29%2C%28B2%2BC2%2B9%29%2A%28C2%2BD2%2B6%29%2A2%2AA2%2F10000%2CIF%28AND%28C2)
x)KHNyھ
O'z9e]mn~.FvF:AFFz::z l
$tLj55u4-5]4
>mm:plm~ͰkiӶO[W<5fQ$ف tu
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
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
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