| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula that will change a text that is in a cell in to percentage
I am trying to create a form for customers to answer 10 different questions
so that it will calculate a price for them. The 10 questions they have to answer is chosen from a list of drop down answers that I have provided for them. When they choose let's say "Commercial" instead of "Residential" it will represent a different percentage, so that I can formulate the price for them. My problem is I do not know how do display "Commercial" but it really will give me a value of 20%. -- Thank you for your help Andy B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula do I use to find a percentage change? | Excel Discussion (Misc queries) | |||
| Change cell color when a percentage is reached | Excel Discussion (Misc queries) | |||
| Need formula to figure out percentage of change for 5 years | Excel Discussion (Misc queries) | |||
| Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
| How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Threaded Mode
