EXCEL 同时显示公式及结果

 

       朋友们在工作中有时需要在不同的单元格同时显示公式及结果(存放公式的单元格为文本类型),一个比较好的方法就是利用宏表函数中的"EVALUATE"    (None of these cells had an equal sign and as such the cells were seen as Text by Excel. The person wanted to leave the original cell contents intact and use Column B to return the result of the equations.we can get an answer by using an old Excel 4.0 Macro function called EVALUATE.)
        注：宏表函数是早期低版本excel中使用的，现在已由VBA代替它的功能,但仍可以在工作表中使用，不过宏表函数只能在"定义的名称"中使用.
1) Select cell B1
2) Go to Insert>Name>Define
3) Type the name Result (can be any valid range name)
4) In the Refers to: box type: =EVALUATE($A1)
5) Click Add then OK.