隨機產生乘除各一 (9877)

(順序 1) B1:B16=MID("×÷",RANDBETWEEN(1,2),1)

(順序 2) D1:D16=MID("×÷",(B1="×")+1,1)

(順序 3) E1:E16=RANDBETWEEN(1,9)

(順序 4) A1:A16=IF(B1="÷",C1,1)*RANDBETWEEN(1,9)

(順序 5) A1:A16複製到C1:C16