二菱型左移步數 計算交叉格數 (12761)

W2=IFERROR(SUMPRODUCT(ROW(INDIRECT("1:"&INT(U2/2)))*2-1)*2+MOD(U2,2)*U2,1)

另解=SUMPRODUCT((ROW($1:$9)<(U2+0.1)/2)*(ROW($1:$9)*2-1))*2+MOD(U2,2)*U2