Forum Discussion
Fetch formula from cell (or dropdown box)
I have a table with a calculation, and would like to easily switch formulas.
So I'd have a list of formulas next to the table, and with a dropdown box, would like to let the user choose which formula is used in the table.
Attached a simple example of the concept (screenshot below). The formula in the column "Result" should adapt to the selection in a dropbox, which would show Formula1, Formula2, etc.
You could do it using IF, IFS, or perhaps SWITCH depending on how many formulas you plan to have.
You could also try the Evaluate function, which only works as a named formula in the name manager (attached).
3 Replies
- JMB17Bronze Contributor
You could do it using IF, IFS, or perhaps SWITCH depending on how many formulas you plan to have.
You could also try the Evaluate function, which only works as a named formula in the name manager (attached).