Thanks Andy, I figured it out. The formula was reading data from fields
saved as text instead of numbers. Once I converted the text to numbers, the
result showed in the cell.

"kanye" wrote:

The cell shows the formula itself. The formula is correct b/c I see the
result when I do Insert, Function, and insert my arguments.

"Andy" wrote:

Hi

You say the result is not reflected in the cell. What is in the cell, then?
If it's a wrong result, check Tools|Options|Calculation is set to Automatic.
If it's the formula itself try Tools|Options|View and uncheck Formulas.
Otherwise post back!

Andy.

"kanye" wrote in message
...
I've inputed a formula that generates a result when I do Insert Function
and
enter the argument; however, the result is not reflected in the cell.
I've
tried to cut and paste the formula as a Paste Special, Values only but
that
doesn't work. Please advise.