取連續三位數 (10121)


H3=MID("01234567890109",MOD(F3-(F3=0),13),3)


另解=TEXT(SUM(MOD(ABS((F3+{-1,0,1})),10)*{100,10,1})+(F3=0)*8,"000")


另解=IF(F3,RIGHT(0&SUM(RIGHT(TEXT(F3+{-1,0,1},"0;9;0"))*{100,10,1}),3),109)


留言