text in formula explaining formula not to print
 

I think i saw one day that one can put an explanantion of a formula as part
of theformula but this does not influence the formula nor does it print or
reflects on the spreadsheet. it only reflects if you click on the cell and
the formula is reflected on the top line. is there still a way to do this in
excel?

One way:

=A1 * A2 + N("Mark up base cost")

N(text) = 0, so won't change the result of the calculation.


In article ,
Leon Klopper <Leon wrote:

I think i saw one day that one can put an explanantion of a formula as part
of theformula but this does not influence the formula nor does it print or
reflects on the spreadsheet. it only reflects if you click on the cell and
the formula is reflected on the top line. is there still a way to do this in
excel?