excel 关于如何用函数公式,来判断单元格区间是否存在递增数列或递减数列...答:=IF(MIN(N(SMALL(序列2,{1,2,3,4,5})=TRANSPOSE((序列2)))=1,"递增函数",IF(MIN(N(LARGE(序列2,{1,2,3,4,5})=TRANSPOSE((序列2)))=1,"递减函数",""))或者 =IF(MIN(N(SMALL(序列2,{1;2;3;4;5})=(序列2)))=1,"递增函数",IF(MIN(N(LARGE(序列2,{1;2;3;4;5...
要求用函数实现一列中数值递增,个数递减。有难度,大神进答:A1=IF(ROW()<6,0,IF(ROW()<10,1,IF(ROW()<13,2,IF(ROW()<15,3,IF(ROW()<16,4,"")))或 A1=IF(ROW()<16,(LOOKUP(ROW(),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,0,0,0,0,1,1,1,1,2,2,2,3,3,4})),"")下拉公式。