Proffskon
10-06-2023, 12:21 AM
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?
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?