Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making comments show - momentarily Roger on Excel Excel Programming 3 September 1st 08 05:10 PM
Making comments appear in the center of the screen. Tonso Excel Discussion (Misc queries) 3 July 27th 06 12:13 AM
extracting comments in a cell and making these part of the Chart . Charles Charts and Charting in Excel 2 April 19th 05 03:40 PM
Making comments apply to more than one cell Evelyn Excel Discussion (Misc queries) 2 February 9th 05 12:08 AM
Making blocks of text comments er Excel Programming 1 December 16th 04 08:46 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"