|
楼主 |
发表于 2014-10-22 15:57
|
显示全部楼层
baksy 发表于 2014-10-22 15:38
看看这个公式怎么样?
=N(OFFSET(I$2,INT(MOD(A2*10,1)*10),(LOOKUP(A2,{0,0.25,0.401,0.651},{1,2,3,4})- ...
选择的区域很多,数据量大,右侧表向右拉会看到从0-20,共分0-0.249,0.25-0.4,0.401-0.65,0.651-1,1.001-1.1,1.101-1.24,1.241-1.578,1.579-2.205,
2.206-2.805,2.806-3.158,3.159-4.734,4.735-6.314,6.315-7.892,7.893-9.474,9.475-11.058,11.059-12.642,12.643-14.226,14.227-
15.808,15.809-16.642,16.643-17.226,17.227-18.808,18.809-19.226,19.227-20
0 | 0.249 | 0.25 | 0.4 | 0.401 | 0.65 | 0.651 | 1 | 1.001 | 1.1 | 1.101 | 1.24 | 1.241 | 1.578 | 1.579 | 2.205 | 2.206 | 2.805 | 2.806 | 3.158 | 3.159 | 4.734 | 4.735 | 6.314 | 6.315 | 7.892 | 7.893 | 9.474 | 9.475 | 11.058 | 11.059 | 12.642 | 12.643 | 14.226 | 14.227 | 15.808 | 15.809 | 16.642 | 16.643 | 17.226 | 17.227 | 18.808 | 18.809 | 19.226 | 19.227 | 20 |
|
|