B2=IF(IF(ROUND((A2-$B$1)/$B$1*100,0)>0,ROUND((A2-$B$1)/$B$1*100,0)*2,IF(ROUND((A2-$B$1)/$B$1*100,0)<0,ROUND((A2-$B$1)/$B$1*100,0)*(-1),0))>20,20,IF(ROUND((A2-$B$1)/$B$1*100,0)>0,ROUND((A2-$B$1)/$B$1*100,0)*2,IF(ROUND((A2-$B$1)/$B$1*100,0)<0,ROUND((A2-$B$1)/$B$1*100,0)*(-1),0)))
向下复制到B9
B2=IF(IF(A2>=$F$1,CEILING(ABS((A2-$F$1)/$F$1*100),1)*2,CEILING(ABS((A2-$F$1)/$F$1*100),1)*1)>20,20,IF(A2>=$F$1,CEILING(ABS((A2-$F$1)/$F$1*100),1)*2,CEILING(ABS((A2-$F$1)/$F$1*100),1)*1))