C2è¾å ¥
=LOOKUP(A2,IF(B2="åå±",{0,80,95,110,125},{0,85,100,115,130}),{1000,800,500,350,150})
å ¬å¼ä¸æ
我是想在表格里输入多层,129,公式就直接得出350
追答“多层”和“129”都在同一单元格、还是分开?
追问分开
追答“多层”在A1、“129”在B1。
C1输入
=IF(A1="多层",LOOKUP(B1,{0,86,101,116,131,151},{1000,800,550,350,150,""}),IF(A1="单层",LOOKUP(B1,{0,81,96,111,126,1146},{1000,800,550,350,150,""}),""))
回车。