I want to define a list of formulas, that take other cells as arguments, and choose the formula whose answer I get with yet another cell

[aristotle2600]

Let’s say I have 10 labels, text strings, in cells A1:A10. Next to those cells, in B1:B10, I have 10 formulae, that each take a cell, a number, as an argument.

Now, in A12:A14, I type text strings that will each match one of the above 10, and in B12:B14, I type 3 different numbers. I want C12:C14 to have the results of plugging the numbers B12:B14 into the equation signified by the text string typed in A12:A14. How do I do this? Can it be done with the spreadsheet stuff, or do I need to figure out how to write a custom function?

[Regina]

See example Ask 2014-03-18 choose formula.ods

That can be done with MULTIPLE.OPERATIONS. But putting all in one formula makes it hard to understand. I would introduce an additional range for showing the cell address of the range B1:B10, see sheet2, and so separate the search for the formula from calculating the value.