ExcelҪӦþùʽм㡣Ǵ㣬Ԫ㣬ֻҪһԪ빫ʽܵõֱʾƶھ˵õģĳЩ¾Ͳôˡ˵ʩԤдʹExcelҪдļʽҲҪĽͬĹʽExcelҪΣһıʽĵԪ빫ʽһݸʽĵԪ빫ʽExcel 
μܿʽܿأΪԴ濼ǣһַν֪ʾʽݸʽԪ빫ʽExcelȻڵĵԪпʽһַν֪ʽʾһıʽĵԪ빫ʽڵĵԪп
֪ʾʽ
CΪͨʽõĽC1Ϊ=A1+B1ֱ㡰=2+3)ڵDҪʾʽĵطD1ӦʾΪ=A1+B1ߡ=2+3
1. 򿪡ߡ˵ѡѡ֡ѡԻ
2. ڡ桱ѡУѡСR1C1÷ʽѡ
3.ƣλáɡ=GET.CELL(6,Sheet1!RC[-1])ɡRC[-1]ڵǰԪͬǰһеԪйʽڵǰԪеõʽݣںʽԪͬкһеԪʾʽݣRC[-1]ΪRC[1]ڹʽͬǰһеԪʾʽݡ
4.λáкСRC[-1]ںʽԪͬкһеԪ롰=FormulaofResultɵõʽλáкСRC[1]ںʽԪͬǰһеԪ롰=FormulaofResultɵõʽ
ʾҪںʽԪͬк2ʾʽݣҪѡλáеġRC1ΪRC2
֪ʽʾ
CΪûеȺŹʽC1ΪA1+B1)ڵDҪŹʽĵطD1ʾA1B1ԪӵĽ
1. ѡD1Ȼ򿪡롱˵ѡơеġ塱֡ơԻ
2.ڡڵǰеơ붨ơResultofFomula·ġλá༭롰=EVALUATE(Sheet1!C1)[ȷ]ť˳
3.  D1롰=ResultofFomulaȻѡаס½ǵ伴ɡ
ʾEVALUATEEexcel4.0ĺExcel 2000Excel2002лֻ֧֣ƶС
4. Ҫ[F9]㣬CеĹʽиĶҲҪʱ[F9]㡣
ʩƣùʽͽExcelкƽˣҲ԰ɡ
