About Us

Thanks Dave
That will work fine.
"Dave Peterson" wrote in message
...
You're gonna need some VBA to evaluate the expression.

Option Explicit
Function Eval(myStr As String) As Variant
Eval = Application.Evaluate(myStr)
End Function

Then you'd use:

=eval(SUBSTITUTE(SUBSTITUTE(TRIM(D4),"/","*")," ","+"))
in your cell.

You could do the substitutes in code, too. But then you couldn't use your
=eval() without those substitutions.

Option Explicit
Function Eval(myStr As String) As Variant
With Application
Eval = .Evaluate(.Substitute _
(.Substitute(.Trim(myStr), "/", "*"), " ",
"+"))
End With
End Function

Then you'd use:
=eval(d4)

In either case...

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Now go back to excel.
Into a test cell and type:
=eval(a1)

Neil wrote:

I have a list of quantites in one cell "D4"
"D4" = 6/6 3/2.6 5/1.2.
I need to sum each of these to a total so I use the following formula
=SUBSTITUTE(SUBSTITUTE(TRIM(D4),"/","*")," ","+")
Result: "6*6+3*2.6+5*1.2"
How can I convert the result to a formula that would show the sum 49.8

Thanks for any help.

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a Formula in Cell X modify Cell Y?	alMandragor	Excel Discussion (Misc queries)	7	February 10th 05 09:51 PM
looking for a formula	Amanda	Excel Worksheet Functions	5	January 5th 05 07:37 AM
How do I add a date formula to a cell but hide the contents with .	Emzy Wemzy	Excel Discussion (Misc queries)	2	December 12th 04 01:48 PM
How can I write an if-then formula for 0 or less than 0 in cell t.	Baz1	Excel Worksheet Functions	1	November 30th 04 04:33 PM
How do I do math on a cell name in formula?	Mark Mulik	Excel Worksheet Functions	3	November 23rd 04 03:43 PM

Menu

About Us