Display formula in Numbers
Is there any way to make Numbers display a formula?
I want it to display the formula in a header cell that will be used in that row.
Pages has an option to use LaTeX but I can't find it in Numbers.
Is there any way to make Numbers display a formula?
I want it to display the formula in a header cell that will be used in that row.
Pages has an option to use LaTeX but I can't find it in Numbers.
Ahhh, i see now. You dont want to show the formulas as they are in the cells being calculated, you want to have a header that shows what formulas are being done in the column cells below the header.
Sorry, but you already discovered that Numbers doesn't do Latex (as far as you and I can find). But since Pages does, I have a quick workaround.
Do the Latex in Pages, then take a screenshotof the Latex style formula, and use the copy/paste you already discovered and put it as the header background in numbers.
I know its not perfect, but maybe it might be a workaround that will work for you,
Jason
You can type an apostrophe followed by = the formula and it will display in the cell as text rather than as a live formula.
SG
Display formula in Numbers