在Sheet2的B2单元格输入以下公式，然后向右向下填充公式=IF(Sheet1!B2="","",IF(Sheet1!B2<0.15,80*Sheet1!B2,IF(Sheet1!B2<0.3,160/3*Sheet1!B2+4,IF(Sheet1!B2<0.5,50*Sheet1!B2+5,30))))
