View Single Post
  #2   Report Post  
Jimbola
 
Posts: n/a
Default

Hi Frank,

Evaluate is not a function, hence u can't see it in the function list. It is
a formula auditing tool, located in Tools Formula Auditing Evaluate
Formula (EF) .
Basicaly if you enter a formula in a cell and use the EF it will show you
exactly how the result is calculated. Even if the result turns our to be an
error. Using it if you have a formula with many parts you can see how each
part is worked out by Excel.
It was introduced in Excel 2002(XP).

HTH

"Frank H." wrote:

I have looked on the internet but can't seem to find much
information on Excel's EVALUATE Function. I see it being
used but don't seem to have it in my function list with
Excel 2003. Can someone provide an explanation of the
EVALUATE function i.e. what it does, a little history,
etc. Thanks for your help.