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.
|