subscribe  It's quick and easy!

Access to 130 free guest articles, discussions and more, just create your free OfficeUsers User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Available to Members = Members-Only     Available to Registered Guests = Registered Guests.


Available to MembersUse labels in your calculation
 Article Abstract:

(Eelco Henderichs) The use of cell address in formulas makes it heard to understand what is calculated. Especially in complex spreadsheets. Use labels to make them easier to read and understand.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Advanced Dates and Times in Excel
Advanced Excel Filters
Advanced Excel Validations
Advanced Validation Techniques with Excel
MS Office 2003 XML - Not exactly as they promised
Excel Sorting Subtotals and Outlines
Advanced Excel Security
Formulas Don't Calculate as Formulas
Excel Custom Functions/Formulas - Excel User Defined Functions/Formulas

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati


Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
Reader Comments: Post Your Comments/Feedback

RE: Use labels in your calculation
by Prithvi Bhardwaj (posted: 11/5/2007 3:14:28 PM)
I tried to do that but it is not working. The formula =sum(Q1) doesn't fetch anything.

I thought it would be a good substitute of "Named Ranges", but it is not working......Warm Regards....prithviraj_bhardwaj@yahoo.com


RE: Use labels in your calculation
by Prithvi Bhardwaj (posted: 11/5/2007 3:40:00 PM)
When I tried to copy the labels from your article, the formulas were not functioning correctly...It's ok
   



 
 
[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2008, Bits on the Wire, Inc.  

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.