Use a Text Based Formula from one cell as the actual formula in another

Asked Apr 12 '19 at 13:54

Active Apr 12 '19 at 13:54

Viewed 61 times

I have a scenario that i am unable to figure out. What i am trying to do is build up a complex formula in a cell that is text based. I then want to use the result of that text based formula as the actual formula in another cell. Is this even possible?

Example:

B1 = 2

B2 = 3

B4 = ="B1+B2" in a text format so the result looks like: B1+B2

I want to use the value of B4 as the formula in B5 so that the end result in cell B5 is: 5

I have tried in B5 =B4 but that just results in the text value of B4 which is B1+B2 again. I also tried a few other options and they all fail which is why i am here. Is there a way to accomplish this?

asked Apr 12 '19 at 13:54

PY_

1,189
8
18
29

1

also see: https://superuser.com/questions/253353/excel-function-that-evaluates-a-string-as-if-it-were-a-formula – Scott Craner Apr 12 '19 at 14:00
Thanks! Do i just delete my question then since its a duplicate? I guess i searched for the wrong keywords! – PY_ Apr 12 '19 at 14:11
1

Feel free to leave it, as other may stumble here before finding another and the links will help them – Scott Craner Apr 12 '19 at 14:12
Is there a way to mark yours as the answer and give you kudos? – PY_ Apr 12 '19 at 14:14

Use a Text Based Formula from one cell as the actual formula in another

0 Answers0