Thread: equation as text string and its numeric result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default 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?


Reply With QuoteReply With Quote