假设楼层在A列并从A2开始，你图片中的A值在B列并从B2开始，在C2单元格中输入公式=IF(OR(A2="",B2=""),"",IF(A2<=3,LOOKUP(B2,{0,35.001,41.001;19,15,0}),IF(AND(A2>=4,A2<=6),LOOKUP(B2,{0,23.001,26.001;19,15,0}),IF(AND(A2>=7,A2<=12),LOOKUP(B2,{0,22.001,24.001;19,15,0}),IF(AND(A2>=13,A2<=18),LOOKUP(B2,{0,20.001,22.001;19,15,0}),IF(A2>=19,LOOKUP(B2,{0,11.001,13.001;19,15,0})))))))
拖动填充柄下拉公式。 如图：
