jquery按規(guī)律排列數(shù)字?
使用Lookup 函數(shù), lookup(查找值,數(shù)據(jù)源,返回值){0,50,100,200,300},是數(shù)據(jù)源{6,8,10,15,20},返回的值=A1+LOOKUP(A1,{0,50,100,200,300},{6,8,10,15,20})要使用大括號(hào),大括號(hào)在插入-符號(hào)中可以找到。具體請看圖片
jquery按規(guī)律排列數(shù)字?
使用Lookup 函數(shù), lookup(查找值,數(shù)據(jù)源,返回值){0,50,100,200,300},是數(shù)據(jù)源{6,8,10,15,20},返回的值=A1+LOOKUP(A1,{0,50,100,200,300},{6,8,10,15,20})要使用大括號(hào),大括號(hào)在插入-符號(hào)中可以找到。具體請看圖片