233УСΪ۹ʦԱҲοʹá۹ʦԱϢע233УҲɼ233У-۹ʦ2Ⱥ365916143ȫĿнѧϰ
excelоҪԼʽбעǰvbaһоٶ˺ܶࡣexcelڲпܻһЩһżȻĻᣬ̳Ͽһʵú̼ܲ򻯡ãעҲˡֽùд1ʽdԪ񣬼ʽбע[]磺2*4.5[]+10[a-b]Ϊ19
2롪ơ
3ԶΪjss
4λãr=evaluate(substitute(substitute($d5,"[","*istext(""["),"]","]"")"))
5eÔªÔª=if(d3="","",jss)
6עʱ[ ]Ҫڼʽĺ棬磺2*4.5[]+3*3.3[]
Ô´Û£[nopage]
۹ʦǰӦԼѧϰϵѧϰ̬ʦ˼·ȥתʦγᵽص֪ʶ㣬һҪգѧܽᣬѧһ
۹ʦȻѣҲǹƵģֻҪкѧϰѡʺϵĿγ̣ʹ۹ʦѶٴҲܰˣ233УŶĴ죬ΪʺϵѧϰʦѧЧ֣ͨۿԲѡ

