How to combine formula parts from cells ??

[moogeedoo]

Dears is it able to concat a formula from cells
A1 = 5
B1 = +
C1 = 3
I want to put a formula in D1 to calculate A1, b1 and c1 in example 1 the result should be 8 so if i change the sign "+" in B1 to "-" the result in D1 should be 2 like example 2
example 1

example 2

thanks in advance

 

[Eric W]

There is a way to create a formula from pieces like this, but it's complicated and not really a good idea. Or you could write a UDF and use the VBA Evaluate function. What makes more sense though is to make a list of the possible functions you want in B1, and create a function that does all of them, like this:

Book2
	A	B	C	D
1	5	*	3	8
2	5	-	3	2
3	5	*	3	8
4	5	/	3	1.666667
5	5	^	3	125
Sheet2

Cell Formulas
Range	Formula
D1:D5	D1	=CHOOSE(MATCH(B1,{"+","-","/","*","^"},0),A1+C1,A1-C1,A1/C1,A1*C1,A1^C1)

 

[Eric W]

I just realized that * can be a wildcard, which is why row 3 isn't right. To fix that, it's easiest to use "x" for the times operator instead. Also note that adding the "/" to cell B4 required putting a ' in front of it.

Book2
	A	B	C	D
1	5	+	3	8
2	5	-	3	2
3	5	x	3	15
4	5	/	3	1.666667
5	5	^	3	125
Sheet2

Cell Formulas
Range	Formula
D1:D5	D1	=CHOOSE(MATCH(B1,{"+","-","/","x","^"},0),A1+C1,A1-C1,A1/C1,A1*C1,A1^C1)

 

[moogeedoo]

Thank U Mr. Eric for UR support but like this it will not be a good idea as U said, I will try it in another ways, Merry Christmas