EXCL做一个判断性的表格.现在我想用EXCSL做一个东西:基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1.如果A1为“铅笔”的
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/21 17:24:13
![EXCL做一个判断性的表格.现在我想用EXCSL做一个东西:基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,](/uploads/image/z/7305902-62-2.jpg?t=EXCL%E5%81%9A%E4%B8%80%E4%B8%AA%E5%88%A4%E6%96%AD%E6%80%A7%E7%9A%84%E8%A1%A8%E6%A0%BC.%E7%8E%B0%E5%9C%A8%E6%88%91%E6%83%B3%E7%94%A8EXCSL%E5%81%9A%E4%B8%80%E4%B8%AA%E4%B8%9C%E8%A5%BF%EF%BC%9A%E5%9F%BA%E6%9C%AC%E6%98%AF%E8%BF%99%E6%A0%B7%2C%E5%A6%82%E6%9E%9CA1%E4%B8%BA%E2%80%9C%E4%B9%A6%E6%9C%AC%E2%80%9D%E6%97%B6%E5%80%99%E5%BA%94%E7%94%A8%E5%85%AC%E5%BC%8F%3DIF%28H1%3D0%2C0%2C%28IF%28M1%3E100%2C%221.7%22%2CIF%28M1%3E13%2C%221.6%22%2CIF%28M1%3E10%2C%221.1%22%2CIF%28M1%3E4%2C%222%22%2CIF%28M1%3E0%2C%221.9%22%2C%22%22%29%29%29%29%29%29%29%2AH1.%E5%A6%82%E6%9E%9CA1%E4%B8%BA%E2%80%9C%E9%93%85%E7%AC%94%E2%80%9D%E7%9A%84)
EXCL做一个判断性的表格.现在我想用EXCSL做一个东西:基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1.如果A1为“铅笔”的
EXCL做一个判断性的表格.
现在我想用EXCSL做一个东西:基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1.如果A1为“铅笔”的时候引用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.5",IF(M1>10,"1.1",IF(M1>4,"1.2",IF(M1>0,"1","")))))))*H1.如果为其他东西的时候就应用=IF(H1=0,0,(IF(M1>100,"1.5",IF(M1>13,"1.3",IF(M1>10,"1.1",IF(M1>4,"1",IF(M1>0,"0.9","")))))))*H1..
EXCL做一个判断性的表格.现在我想用EXCSL做一个东西:基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1.如果A1为“铅笔”的
你既然知道用IF,那为何不用IF嵌套,来判断A1的值自动执行对应的公式呢?
你好:可以lookup(). =IF(H1=0,0,IF(A1="书本",LOOKUP(M1,{0,4.01,10.01,13.01,100.01;1.9,2,1.1,1.6,1.7}),IF(A1="铅笔",LOOKUP(M1,{0,4.01,10.01,13.01,100.01;1,1.2,1.1,1.5,1.7}),LOOKUP(M1...
全部展开
你好:可以lookup(). =IF(H1=0,0,IF(A1="书本",LOOKUP(M1,{0,4.01,10.01,13.01,100.01;1.9,2,1.1,1.6,1.7}),IF(A1="铅笔",LOOKUP(M1,{0,4.01,10.01,13.01,100.01;1,1.2,1.1,1.5,1.7}),LOOKUP(M1,{0,4.01,10.01,13.01,100.01;0.9,1,1.1,1.3,1.5}))))*H1
收起