Jan 20 2021 10:07 PM
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.
Jan 20 2021 10:28 PM
Solution
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).
Jan 20 2021 10:28 PM
Solution
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).