數學題 A+B+A*B=計算後值 求二數字值 (12982)

B2:C6{=IFERROR(MID(TEXT(SMALL(IF((ROW($1:$99)+COLUMN($A:$CU)+ROW($1:$99)*COLUMN($A:$CU)=$F$2)*(ROW($1:$99)>=COLUMN($A:$CU)),ROW($1:$99)/1%+COLUMN($A:$CU)),ROW(A1)),"0000"),COLUMN(A1)*2-1,2)*1,"")

D2:D6=IF(B2="","",B2+C2+B2*C2)



留言