How about supporting functions like ABS as EXP in a better way than just as a function name.
How about supporting functions like ABS as EXP in a better way than just as a function name.
Well, if it is possible to choose depending on personal taste and the particular circumstances then that would be brilliant.
I personally find:
To be better looking (and less confusing) than
and easier for the average Excel-user to grasp than
One potentially confusing issue is the introduction of the additional variables such as
and
that may or may not figure as named cells in the sheet already.
I think the matrix abstraction
is nice, and that it may be useful for some situations, but for my audience I am afraid that it will require more in terms of explanations than I am willing to invest.
I see this tool as an elegant way to document (and troubleshoot) complex formulae in Excel and not as a tool for writing mathematical books or reports. For that purpose I prefer
or
over Excel anyway.
One of the very nice features with this Add-in is that it can render whatever you send it. If I need one nice display formula for use in Excel or perhaps Word, I can still write the formula with whatever formatting I need (if it is not too long) and copy it to wherever I want.
BTW, I often use named cells for given constants, and it is slightly annoying that grouping is not possible in the Excel name. This result in silly names like e.g. T_a_m_b to get .
Login