Help! How to evaluate a math expression (in text format)

J

JM

Hi,

I have an string with a math expression, example str = "Log(5) +3 "

How can i convert it into a numeric value?

Thanks,

Jaime
 
A

Albert D. Kallal

Simply use the eval functon.

dim str as string

str = "log(5) + 3"

msgbox "result = " & eval(str)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
Excel does not accept text format! 0
Help!! How to evaluate a Math function in string form 2
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Help! How to convert a math function (string) into a number 1
Math formula help 5
Converting URLs in comments to Markdown-formatted links 2
Help! How to evaluate a math string expression into a number 2

Top