Prev Previous Post   Next Post Next
  #2   Report Post  
agenda9533
 
Posts: n/a
Default

Thank you for you answer.
So, I need to TYPE names in formula....
I thought if I assigned names they would be populated/applyed automatically
in all cells comtained formula.
Was I wrong?

"Significent" wrote:

Unless I'm not understanding your example, there doesn't seem to be anything
special about what you're trying to do. Assuming you assign names to each of
the cells, be sure to put an equal sign in front of the calculation you're
attempting.

Example: You've named three cells name1, name2, and name3 respectively and
typed a value into each. Now let's say you want to multiply the field values
together. The cell containing the formula should read =name1*name2*name3

Does this address your issue?

"agenda9533" wrote:

I want to assign names (labels) instead absolute references in formula.

For constant and non-constaht values.

Example,
Underserving contacts (non-CSS) 500 --constant

Under- serving incidents
--non-constant
19.90049751
44.776
22.388
17.910

I've tried Insert/Name/Define,Create,Apply but it didn't work. Please,
suggest.

 
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
Pivot Table Label Dustin Excel Discussion (Misc queries) 2 January 26th 05 03:25 AM
Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 05:08 PM
Question on LABEL Range Sarah Tanembaum Excel Discussion (Misc queries) 2 December 15th 04 11:49 PM
label problem Raven Maniac Excel Worksheet Functions 5 November 10th 04 10:10 PM
how to remove label formatting (eg label to number) sikkiekaka Excel Worksheet Functions 0 November 4th 04 11:35 PM


All times are GMT +1. The time now is 05:01 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"