Forum Discussion
Mathview function (xl-viking)
peiyezhu, that is a good idea thanks!
I guess I won't be able to show the equation with inserted numbers, but at least I can show formula with symbols (names) shown.
Usually I work with design sheets in columns, where I compare different configurations to find the best one. I give a simple example below, but usually the equation systems are rather long.
If I apply name here, I assume that I will need to distinguish the names in each column, i.e. for each configuration. Normally when I set up the equation system in one column, I just drag the column to the right and change the input parameters and its done. With names I assume that I need to do some more work, designing L1,L2,L3 , W1,W2,W3 and H1,H2,H3?
I assume that I can use "Create from Selection" and "Create Names from values in the: Left Column" to minimize the work. But when I try to do this with C2-C5, I get the following error message:
Regardless if I select C2:C5 or only C2.
Using this command I thought that I could automatically Name C2:C5 "L1", "W1", "H1" and "V1", instead of manually defining the name for each cell.
Do you see anything wrong with this approach?
Appreciate your input.
You can name the input cells, but:
- So far as I know, the cells must be named one-at-a-time. That's tedious.
- Excel will not allow you to use names like L1, W1, H1… because those names would be interpreted as cell addresses. OTOH, L_1, W_1, H_1… could be used.
- A probably-serious disadvantage of naming the cells individually is that you cannot take advantage of Excel's intrinsic ability to modify impacted formulas when you copy cells.
But if you are willing to store your data entities one-per-row (rather than one-per-column, as in your sample data), you can put such data into an Excel table. You can then write formulas (one for each table column) that reference the column names, and there are other advantages. Formulas that reference Excel table data use structured references (like [@Height]) rather than cell references (like D4).
Of course, in either case, you can do simple manipulation of the result of the FORMULATEXT function yourself. See the attached workbook. (My examples are intentionally verbose. One or more could be shortened and/or defined as a named formula(s).)- instead of manually defining the name for each cell.
if you apply formula like C2-C5,you should define the name for each cell.
if you provide your raw workbook file and expected result,more guys maybe interested in joining the discussion.
Because I am not clear what you want in detail.
if your layout like
parameter config
par1 config1
par1 config1
maybe easy to have a batch handle
