EXCEL 同時(shí)顯示公式及結(jié)果

 

       朋友們在工作中有時(shí)需要在不同的單元格同時(shí)顯示公式及結(jié)果(存放公式的單元格為文本類型),一個比較好的方法就是利用宏表函數(shù)中的"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.)
        注：宏表函數(shù)是早期低版本excel中使用的，現(xiàn)在已由VBA代替它的功能,但仍可以在工作表中使用，不過宏表函數(shù)只能在"定義的名稱"中使用.
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.