Question

1,2,3, 4,5,6 7,8,9 10,11,12 13,14,15, 16,17 18,19 20,21 22 23 24 25 十组数分别显示1-----10

=IF(B2<=3,1,IF(B2<=6,2,IF(B2<=9,3,IF(B2<=12,4,IF(B2<=15,5,IF(B2<=17,6,IF(B2<=19,7,IF(B2<=21,8,=IF(B2<=23,9,=IF(B2<=25,10,""))))))))套嵌多过8层了，求解简单好用的方法
1,2,3 4,5,6 7,8,9 10,11,12 13,14,15 1617 1819 2021 22 23 24 25 十组数分别显示1-----10 =IF(B2<=3,1,IF(B2<=6,2,IF(B2<=9,3,IF(B2<=12,4,IF(B2<=15,5,IF(B2<=17,6,IF(B2<=19,7,IF(B2<=21,8,=IF(B2<=23,9,=IF(B2<=25,10,""))))))))套嵌多过8层了，求解好用的方法

Answer 1

太高尖端了，看不懂

Answer 2

封id苏雅歌

追问

什么意思

Answer 3

是IF语句？？？？

Answer 4

(⊙o⊙)…