二數相加 最接近指定數 (15272)

F2:H11{=MID(RIGHT(SMALL(IF(ROW($1:$15)>COLUMN($A:$O),(($B$2:$B$16+TRANSPOSE($B$2:$B$16)<$D$2)*0.5+ABS($D$2-$B$2:$B$16-TRANSPOSE($B$2:$B$16)))*10^6+$B$2:$B$16/1%+TRANSPOSE($B$2:$B$16)),ROW(A1)),4),COLUMN(A1)*2-1,2)*1



留言