# Thread: Formula (Excel 2000/SP3)

1. ## Formula (Excel 2000/SP3)

Last year someone here in the Lounge helped me get a spreadsheet working and one of the formulas used the

2. ## Re: Formula (Excel 2000/SP3)

Hi,

The 'EVAL' function may well be a user-defined function, in which case you should be able to find it by starting the Visual Basic Editor (Alt-F11) and looking in the module(s) attached to the workbook in which the function resides. You'll need to have the 'Project Explorer' visible in the Visual Basic Editor. If it isn't already visible, you'd enable it via Ctrl-R from within the Visual Basic Editor.

Cheers

3. ## Re: Formula (Excel 2000/SP3)

The EVAL function is no normal worksheet function. EVALUATE is an ancient XL4 macro function, which can be used in defined names.

What your function seems to (try to) do is to pick up the list of numers delimited by returns, replace the returns with commas and add a "{" in fromt and a "}" at the back, thus creating an array of values.

So the cell looks like this:

1
2
3

and the formula's result looks like this:

{1,2,3}

If your formula column is -say- column K and your numbers are in column H:

- select the cell in column K (lets assume K5)
- Insert, name, define
Name: EVAL
RefersTo:
=EVALUATE("{" & SUBSTITUTE(H5,CHAR(10),",") & "}")

Now use EVAL in your formula like this:

(A5*\$B\$1-SUM(EVAL)))-I5

4. ## Re: Formula (Excel 2000/SP3)

macropod,

Thanks but he already looked for it that way and so did I and it doesn't appear to be there. I just can't remember how it came about. I'll forward this information though.

Thanks again.

5. ## Re: Formula (Excel 2000/SP3)

pieterse,

Thanks. I will forward this information to my friend and see if that helps him, thus helping out my spreadsheet.

6. ## Re: Formula (Excel 2000/SP3)

Found it. "Eval" is part of an Excel add-in called "morefunc"

Thanks all.

7. ## Re: Formula (Excel 2000/SP3)

The sinner must have been me. Here more info on morefunc:

Download MoreFunc
Function Descriptions

8. ## Re: Formula (Excel 2000/SP3)

Aladin,

No sin involved. In fact it is a rather great formula that was developed around that "eval" function. I just wanted a little enhancement and the person I sent the file to did not have the "morefunc" on his machine until by some stroke of luck I remembered that "morefunc" and sent it to him. After he loaded it as an add-in it took him about 30 seconds to come up with what I needed.

Thanks.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•