Insert formula from text

[FLLPE]

I have a formula written as text in a cell, ie. '=10+5. This formula is in real life much longer, but just think of it as a formula. In another cell, I want to insert the text (=10+5) as a formula, and consequently get the result of the formula (15).

Indirect does not seem to do the trick...

 

[Richard Schollar]

Hi

Indirect returns a range reference, not a formula. You could use an old XLM4 macro function like this (you do need to create a named formula, however, and you can't have cell references in your formula string):

Excel Workbook
	G	H
6	=5+10+5-8*5	-20
Sheet1

Excel 2003

Cell Formulas
Range	Formula
H6	=eval

Excel Workbook
Name	Refers To
eval	=EVALUATE(INDIRECT("RC[-1]",FALSE))
Workbook Defined Names

 

[FLLPE]

Wow, thanks, it works