What *stand-alone* function can I use in place of EVALUATE then?

None! There aren't any worksheet functions that work like Evaluate. See
Anthony's reply. You'd have to use a VBA UDF.

Biff

"Epinn" wrote in message
...
Thank you, Ron, for the information.

Yes, "$" was what I missed. I modify the example and use a range, and it
works beautifully for V. 2003 as well. I like this tip and I see some users
can really apply it.

You CANNOT use EVALUATE in a worksheet cell by itself (you never could).

What *stand-alone* function can I use in place of EVALUATE then?

Epinn

"Ron Rosenfeld" wrote in message
...
On Sat, 14 Oct 2006 19:57:04 -0400, "Epinn"
wrote:

Does EVALUATE( ) still exist in V. 2003? I couldn't find it from Excel
Help. Seeing that DATEDIF can't be found via F1 but still alive and
kicking, I need to hear about EVALUATE ( ) for sure although I think I see
something like "undefined." If it is not available, what do we use now? I
found it from the following writeup. By the way, does naming a formula
goes thru the same steps as naming a range on a worksheet?
InsertNameDefine?

************************************************* *********************

Created by David Hager
To add comma delimited values in a cell (such as 1,2,11,4 in cell A1) to
the right of the cell containing the string, highlight cell B1 (for this
case) and create the following defined name formula (called "csum"):

=EVALUATE(SUBSTITUTE(A1,",","+"))

Then, type =csum in B1 to obtain the result (18, in this case).

************************************************* **************

Thank you for your help.

Epinn



It is still present in Excel 2002.

BUT

EVALUATE is an old macro command from when Excel used to have Macro sheets.

Entering and using it in the manner outlined by Hager still works in Excel
2002
and I'd guess it'd work in Excel 2003. But I believe you need to use an
absolute reference in the defined name formula.

You CANNOT use EVALUATE in a worksheet cell by itself (you never could).


--ron