隨機出題 二數相加小於100與相減大於 0 (13800)

日期：

B2右拉 下拉=SUBSTITUTE(SUBSTITUTE(TEXT(SMALL(IF(ROW($1:$99)+COLUMN($A:$CU)<100,ROW($1:$99)/1%+COLUMN($A:$CU)),RANDBETWEEN(1,COUNT(0/(ROW($1:$99)+COLUMN($A:$CU)<100))))%,"0.00"),".","+"),"+0","+")&"="

H2右拉 下拉=SUBSTITUTE(SUBSTITUTE(TEXT(SMALL(IF(ROW($1:$99)-COLUMN($A:$CU)>0,ROW($1:$99)/1%+COLUMN($A:$CU)),RANDBETWEEN(1,COUNT(0/(ROW($1:$99)-COLUMN($A:$CU)>0))))%,"0.00"),".","-"),"-0","-")&"="



留言

張貼留言