Perform basic operations basen on a cell

[Proffskon]

Thought this was a simple matter. I want the cell to perform the formula based on what operation is specified in another cell.



2
+
2
4


2
-
2
0


2
/
2
1


2
*
2
4



I want someting like this =A1&B1&C1.
i can get aroung this problem with
=OM(B1="+";A1+C1;OM(B1="-";A1-C1;OM(B1="/";A1/C1;OM(B1="*";A1*C1;))))

Is there any other solution to this?

[georgiboy]

You can try the below:

In the ribbon go to: Formulas / Name Manager
Click 'New'
Put: EVAL in the 'Name' box
In the 'Refers to' box put: =LAMBDA(x, EVALUATE(x))

Then in your spreadsheet you can use the EVAL function you created as below:

=EVAL(A1&B1&C1)

EDIT: Forgot to mention, this may only work on Excel 365

[georgiboy]

If you are using an older version of Excel then you could use a small UDF:

Function CalcTextFormula(v1 As String, op As String, v2 As String)
CalcTextFormula = Evaluate(v1 & op & v2)
End Function

Used in the spreadsheet like:

=CalcTextFormula(A1,B1,C1)