is there a way to comment within a formula

[boris]

can you commentate what the formula pieces are WITHIN the
formula? In other words, almost like some character you
can put around a word that denotes what it is you are
writing?

Gratzi

 

[Frank Kabel]

Hi
not possible directly in the formula

 

[Dana DeLouis]

One common way is to use N( ) at the end. Using N("Text") just adds zero.

=SUM(2,3,4)+N("Adds three numbers")

HTH

 

[Jason Morin]

You can but IMO it only makes it harder to read and
decipher the formula. Here's an example:

=A1-B1+N("find the difference")+SUM(C:C)+N("then add
remaining expenses")

which is same as

=A1-B1+SUM(C:C)

HTH
Jason
Atlanta, GA

 

[Dave Peterson]

And you can do the same thing with text, too:

="this is what was in a1: "&TEXT(A1,"$0.00")&TEXT("this is a comment",";;;")

The formula evaluated to:
this is what was in a1: $23.00
with 23 in A1.