Is there a way to add reference text to a formula in numbers?
I would like to have a note as to what the number was for the future.
For example (3*2"text)+(7*4"text two") where the text was ignored by the formula and not visible unless you clicked into the formula.
Thank you
This is a very atypical thing to want to do but, if you really really need to do something like this you can hide it in a SUM function. SUM ignores text.
=(3×SUM(2,"Because I like 2"))+(7×SUM(4, "And four is twice as good"))
A more clear way that does not make the formula so hard to understand would be
=(3*2)+(7*4)+SUM("the two is because I like it and the 4 is twice as good")
A more typical solution is to put a comment on the cell.
This is a very atypical thing to want to do but, if you really really need to do something like this you can hide it in a SUM function. SUM ignores text.
=(3×SUM(2,"Because I like 2"))+(7×SUM(4, "And four is twice as good"))
A more clear way that does not make the formula so hard to understand would be
=(3*2)+(7*4)+SUM("the two is because I like it and the 4 is twice as good")
A more typical solution is to put a comment on the cell.
Hidden text in formula
