Evakuating formulas, which are stored in a cell as strings

[Petijandro]

Dear excel Pros!
How do you evaluate a formula which is stored in a cell?
For example

If(A1=1;C2;"")

IN C2:
sum(A2:D2)

or any other formula.

[Lemice]

Hello,

Not sure what you mean, but you can try to add a "=" in front of your formula, so it will become
=IF(A1=1;C2;"")
and
=SUM(A2:D2)

Also, make sure they are not formatted as text (press Ctrl-1, and choose "General" for example, then add a "=" in front of your formula, then hit enter)

[dhn46]

If you want to evaluate a formula which is stored in a cell, you must use macro4 fomulas
A
1 1
2 2
3 Sum(A1:A2)
4 =Eva


Excel tables to the web >> Excel Jeanie HTML
Step 2: In C3 type : =Eva