How can i reference a named formula in each row of a table?

How can i reference a named formula in each row of a table?

I have several named formula in a document that aren’t in a table. These are just free floating formula that are all different except that they all result in a numeric value. I’d like to create a 2 column table that uses the results from those formula. In the first column I want each row to reference a formula and show it’s result. The second column should have a column formula that applies to each row. I also want to do a summary in the footer for each column.

There is a way but it’s not pretty, you need to hardcode the formulas in a Switch:

3 Likes

thanks, that seems to do it