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为“铅笔”的
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
收起