Your cell format is set to Text. Change the format of the cell to
General. Reenter the formula.

In article ,
"kanye" wrote:

The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.