2021-02-23excel数值区间
2021-02-23 本文已影响0人
小鱼儿spr
=VLOOKUP(D2,{0,"010";10,"1020";20,"2030";30,"3040";40,"4050";50,"5080";80,"80~100";100,">=100"},2)
=VLOOKUP(D2,{0,"030";30,"3050";50,">=50"},2)
=IF(MOD(ROW(A1),100)=0,100,MOD(ROW(A1),100))
=CEILING(ROW(A1)/100,1) 按100分组，1-100为第一组，下一个1-100为第二组
