excel生成的加减乘除运算,怎样生成答案方便核对结果呢?
发布网友
发布时间：2022-05-13 10:55
共4个回答
热心网友
时间：2023-08-19 05:35
在EXCEL中需要先定义名称
公式，定义名称，名称起名随便，我这起名ss
引用位置=EVALUATE(SUBSTITUTE(Sheet6!A1,"=",""))
把上面的表名改为你的实际表名
然后在结果列输入
=ss
结果就出来了
如果在WPS里，结果列输入=evaluate(substitute(a1,"=",""))
可直接出结果
热心网友
时间：2023-08-19 05:36
按你目前这样的就很难操作了呀！！
其实，操作上很简单的，只要运用2个列来自动生成随机数，最后通过函数公式实现公式的显示和直接核算出结果。
例：
B2=RANDBETWEEN(1,1000)
C2=CHOOSE(RANDBETWEEN(1,4),"＋","－","×","÷")
D2=RANDBETWEEN(1,1000)
则可在F2单元格输入公式：
=CHOOSE(MATCH(C2,{"＋","－","×","÷"}),B2+D2,B2-D2,B2*D2,ROUND(B2/D2,2))
复制并下拉B2:F2，即可得到你想要的效果了。
若是想结果不显示出来，则可以隐藏整个F列，打印出来的就是没有答案的公式计算式啦…………
若你使用的是高版本的WPS等包含有EVALUATE函数的，则可在B2单元格输入公式：
=EVALUATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"=",""),"×","*"),"÷","/"))
复制并下拉，即可…………
热心网友
时间：2023-08-19 05:36
A2=CHOOSE(MATCH(,0/FIND({"+","-","×","÷"},A2),),TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19))+TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19)),TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19))-TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19)),TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19))*TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19)),TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19))/TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,RIGHT(A2),),LOOKUP(MATCH(,0/FIND({"+","-","×","÷"},A2),),{1,2,3,4},{"+","-","×","÷"}),REPT(" ",19)),19)))
另外，算式用下面的公式，供参考（公式中没有用到引用）：
=TEXTJOIN(LOOKUP(RANDBETWEEN(1,4),{1,2,3,4},{"+","-","×","÷"}),,RANDBETWEEN(15,499)+500,TEXT(800-RANDBETWEEN(5,799),"#="))
公式基本上能实现被减数大于减数。还可根据需要修改公式中499、500、800、799等，使之符合自己的意图。
热心网友
时间：2023-08-19 05:37
vba一键生成
