Thread: label
View Single Post
  #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.