Forum Discussion

Iron Contributor

Jan 21, 2021

Solved

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 formul...

fetch-formula-from-cell.xlsx11 KB

Formulas and Functions

JMB17
Jan 21, 2021
bartvana

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).
fetch-formula-from-cell.xlsm11 KB

Bronze Contributor

Jan 21, 2021

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).

fetch-formula-from-cell.xlsm11 KB

Iron Contributor

Jan 21, 2021

Great, thanks!

JMB17
Bronze Contributor
Jan 21, 2021
You're welcome.

Resources