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УŶĴ죬ΪʺϵѧϰʦѧЧ֣ͨۿԲѡ