| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
equation as text string and its numeric result
How can I type an equation in one cell as a text string eg. "2+3+(5+6)*6"
and get its result in the other one? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
equation as text string and its numeric result
Do a search of the newsgroups looking for Eval - you can define a User-
defined Function making use of Evaluate to do this. Hope this helps. Pete On May 4, 11:01 am, patryk wrote: How can I type an equation in one cell as a text string eg. "2+3+(5+6)*6" and get its result in the other one? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
equation as text string and its numeric result
Try this tiny UDF:
Function value_of(r As Range) As Variant value_of = Evaluate("=" & r.Value) End Function -- Gary''s Student - gsnu200718 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Numeric from a Text String - Help? | Excel Discussion (Misc queries) | |||
| Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
| Extrapolate numeric values from text string | Excel Worksheet Functions | |||
| Find first numeric value in text string | Excel Worksheet Functions | |||
| Equation in text string? | Excel Discussion (Misc queries) | |||
Linear Mode
