Excel怎样查找一个单元格的值在某个范围并返回另一个值?答:=ROUNDUP((A1-2599)/2000+1,0)*2000 或者=LOOKUP(A1,{0,2600,4600,6600,8600,10600,12600,14600,16600,18600,20600,22600,24600,26600,28600,30600,32600,34600,36600,38600,40600,42600,44600},{2000,4000,6000,8000,10000,12000,14000,16000,18000,20000,22000,24000,26000,28000,30000,32000,...