is there a way to comment within a formula

B

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
 
D

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
 
J

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
 
D

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.
 
Top