View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sali[_2_] sali[_2_] is offline
external usenet poster
 
Posts: 24
Default making comments within a formula

"KG83" wrote in message
...
Bob,

Thank you so much! That is perfect for what i need.


=126.22+N("Mechanic")+38.56+N("Medication")+37.93+ N("Rubios bar and
grill")


just to mention, maybe is more effciient and readable to have the next
layout:

on column, say "x" from row 5 to row 10 place numerical expenses vaules, on
column "y", next to numerical, put textual comments. and finaly, on column
"m" [misc] in desired row put just a sum formula for "x" column, like
=sum(x5:x10)

on that way you have readable and printable comments. selecting cell in
column "m" and placing cursor in formula bar, you may see what subrange it
refers, and what i the misc comment