Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I give text a changeable numeric value?
I'm in the AV business and I am creating a room/speaker worksheet where on
Sheet 1, there is a drop down cell for each room that references a list from Sheet 2 of (1) available speaker types and (2) the added price so that I can chage it from time to time. Column A would be Classic, Architectual, Extreme, Yard and column B would be $0, $400, $600, $800 respectively. The resulting drop down name on Sheet 1 would be a combination of the 2 columns from Sheet 2. For example "Classic ($0)" or "Yard ($800)" with the parenthesis. Once 1 of the 4 is chosen, I would like that cell to have the dollar value that it represents so that after selecting the type of speaker for each room there will be a total of added expense at the bottom of the form. Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
give text a dollar numeric value | Excel Worksheet Functions | |||
user-changeable drop-down lists | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
Changeable Row sizes to fit in the text! | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) |