Hello,
Is there a good way to determine the operation I want to perform in a formula by another cell. Something like the INDIRECT() function, but this doesn't work for my purpose.
As an example (if INDIRECT worked):
B1 = INDIRECT(5&A1&5)
If A1 = *, B1 would be 25
If A1 = +, B1 would be 10
If A1 = /, B1 would be 1
...etc
Thanks!
Bookmarks