Build formula from string with reference to other cell/s with operator
I would like to be able to have a formula where in a formula can be build with operators in another cell. As an example where =formula(a1&b1&c1) where the cells would have 1 + 1. in other words b1 would have a + in it. This will make it possible to change operator in a large amount of formulas with only changing input in one cell.
2
votes
Thomas K
shared this idea