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?