字符串的積 (10254)


B2{=PRODUCT(TEXT(RIGHT(SMALL(IFERROR(LEFT(TRIM(MID(SUBSTITUTE(A2,"*",REPT(" ",99)),ROW($1:$9)*99-98,99)),COLUMN(A:I))*1,)+ROW($1:$9)*10^8,ROW($1:$9)*9),8),"0.00;;1")*1)


留言