| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I assign a fixed number value to text?
So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a fixed number value to text?
Example? Please be more specific when you ask a question.
"GooseGirl" wrote: So when the text is selected, there is an underlying value that can be totaled, for example. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a fixed number value to text?
I want to create a simple drop-down list, i.e., apples, bananas and cheese.
Apples would have a background (unseen) value of 12, bananas 9 and cheese 4. After items were selected from the drop-down list, the unseen value could be totalled at the bottom of the list. "Toppers" wrote: Example? Please be more specific when you ask a question. "GooseGirl" wrote: So when the text is selected, there is an underlying value that can be totaled, for example. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a fixed number value to text?
One way:
Sum the list with: =SUMPRODUCT((C3:C23={"Apples","Bananas","Cheese"}) *({12,9,4})) Where the dropdown list is in C3:C23 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "GooseGirl" wrote in message ... I want to create a simple drop-down list, i.e., apples, bananas and cheese. Apples would have a background (unseen) value of 12, bananas 9 and cheese 4. After items were selected from the drop-down list, the unseen value could be totalled at the bottom of the list. "Toppers" wrote: Example? Please be more specific when you ask a question. "GooseGirl" wrote: So when the text is selected, there is an underlying value that can be totaled, for example. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a fixed number value to text?
Thanks, Sandy. It worked perfectly!
"Sandy Mann" wrote: One way: Sum the list with: =SUMPRODUCT((C3:C23={"Apples","Bananas","Cheese"}) *({12,9,4})) Where the dropdown list is in C3:C23 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "GooseGirl" wrote in message ... I want to create a simple drop-down list, i.e., apples, bananas and cheese. Apples would have a background (unseen) value of 12, bananas 9 and cheese 4. After items were selected from the drop-down list, the unseen value could be totalled at the bottom of the list. "Toppers" wrote: Example? Please be more specific when you ask a question. "GooseGirl" wrote: So when the text is selected, there is an underlying value that can be totaled, for example. Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a fixed number value to text?
You're welcome. Thanks for the feedback.
-- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "GooseGirl" wrote in message ... Thanks, Sandy. It worked perfectly! "Sandy Mann" wrote: One way: Sum the list with: =SUMPRODUCT((C3:C23={"Apples","Bananas","Cheese"}) *({12,9,4})) Where the dropdown list is in C3:C23 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign a number value to a text. ie, PL equals .5 | New Users to Excel | |||
| Charts: want to assign fixed color for each slice | Excel Discussion (Misc queries) | |||
| Charts: want to assign fixed color for each slice | Charts and Charting in Excel | |||
| How do I assign a text value to a variable number of rows? | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
