![电子表格怎么给孩子出数学题](/zb_users/upload/2023/11/c3ede70a890611ee9a225254000ebf90.jpeg)
a1,c1,e1输入 =ROUND(RAND()*100,0)b1输入 =IF(A1>C1,"-","+")d1输入 =IF(IF(B1="-",A1-C1,A1+C1)>E1,"-","+")f1输入 = 需要多出几个题目,直接选中下拉就OK了其实把b1,d1写得这么麻烦,主要是怕负数出现
a1,c1,e1输入 =ROUND(RAND()*100,0)b1输入 =IF(A1>C1,"-","+")d1输入 =IF(IF(B1="-",A1-C1,A1+C1)>E1,"-","+")f1输入 = 需要多出几个题目,直接选中下拉就OK了其实把b1,d1写得这么麻烦,主要是怕负数出现