How to convert an equation to number format

[Ratan Bhushan]

HEy Guys

I have equations in my columns like below

(9.78 * 3.9 ) + (1 * 0.4 * 3.9 )

but these are in text... is there any formula to convert this to number and get the result of all the calculation.

 

[Sathish KV]

Hi,

Could you upload a sample file

 

[Faseeh]

Please see this:

http://stackoverflow.com/questions/4471884/turn-a-string-formula-into-a-real-formula

 

[Ratan Bhushan]

I have uploaded the file in which it has a formula to extract the equation, I am not able to go further. please look into this

 

[Ratan Bhushan]

Please see this:

http://stackoverflow.com/questions/4471884/turn-a-string-formula-into-a-real-formula

It is not working sir...

 

[Mike H..]

It is not working sir...

Hi,

Have a look at the attached workbook. The calculations are done in 2 parts. A formula to extract the relevant data (Column I)and a user defined function to evaluate the text string (Column K).

The workbook is now macro enabled.

 

[Ratan Bhushan]

Hi,

Have a look at the attached workbook. The calculations are done in 2 parts. A formula to extract the relevant data (Column I)and a user defined function to evaluate the text string (Column K).

The workbook is now macro enabled.

function is not woking its giving error
#NAME?
Please suggest

 

[Mike H..]

function is not woking its giving error
#NAME?
Please suggest

Hi,

My apologies. I originally did a solution that used a function from the MOREFUNC addin and then changed my mind and used a VB user defined function but uploaded the wrong workbook. Try this one