-
Perform basic operations basen on a cell
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules