我想把行的每一个数，减去列中每一个数。然后根据计算结果，找到区间，并给出对应字母。可以这样计算+逻辑嵌套么？验证结果都是0，本来B7=B2-A7=71.037，应该对应返回A的！求高手指点
=LOOKUP(B$2-$A2,{57.01646, 57.02646, 71.03211, 71.04211, 87.02703, 87.03703, 97.04776,97.05776, 99.06341, 99.07341, 101.0427, 101.0527, 103.0042, 103.0142, 113.0791,113.0891, 114.0379, 114.0479, 115.0219, 115.0319, 128.0536, 128.0636, 128.09,128.10, 129.0376, 129.0476, 131.0355, 131.0455, 137.0539, 137.0639, 147.0634,147.0734, 156.0965, 156.1061, 160.026, 160.036, 163.0583, 163.0683, 186.0743,186.0843}, {"G", "0", "A", "0", "S","0", "P", "0", "V", "0","T", "0", "C", "0", "L","0", "N", "0", "D", "0","Q", "0", "K", "0", "E","0", "M", "0", "H", "0","F", "0", "R", "0", "X","0", "Y", "0", "W", "0"})
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2018-3-6 13:54
发表于 2018-3-6 14:00
