excel负数怎么按区间赋值?答:=IF(A2<=-15,1,IF(A2<=-10,2,IF(A2<=-5,3,4)))=IFS(A2<=-15,1,A2<=-10,2,A2<=-5,3,1,4)=IF(A2>-5,4,IF(A2>-10,3,IF(A2>-15,2,1)))=IFS(A2>-5,4,A2>-10,3,A2>-15,2,1,1...
在Excel中将一个单元格数字,按照规定区间自动填充到多个单元格,如图...答:C2公式:=IF(AND(ROW(A1)<6,A$2-SUM(C$1:C1)>CHOOSE(ROW(A1),100,400,500,4000,5000,10000)),CHOOSE(ROW(A1),100,400,500,4000,5000,10000),A$2-SUM(C$1:C1))下拉。