Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |