本帖最后由 yyyydddd8888 于 2013-12-13 12:33 编辑
- =LOOKUP(A3,{"板a","板b","园a","园b"},{1.15,1.2,1,1.1})*LOOKUP(B3,{0,204;0.25,157;0.5,126;1,105;3,91;5,83})
复制代码- =CHOOSE(MATCH(A4,{"园a","园b","板a","板b"},),1,1.1,1.15,1.2)*CHOOSE(MATCH(B4,{0,0.25,0.5,1,3,5}),204,157,126,105,91,83)
复制代码 下拉
|