Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Label | Excel Discussion (Misc queries) | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Question on LABEL Range | Excel Discussion (Misc queries) | |||
label problem | Excel Worksheet Functions | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |