| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that will change a text that is in a cell in to percentage
You either want an If statement, or a Vlookup table.
Try something like: =if(a1="Commercial",20%,10%) Regards Fred "Andy" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that will change a text that is in a cell in to percen
Thank you! Thank you! Thank you! That was just what I was looking for. You
are awsome. -- Thank you for your help Andy B. "Fred Smith" wrote: You either want an If statement, or a Vlookup table. Try something like: =if(a1="Commercial",20%,10%) Regards Fred "Andy" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that will change a text that is in a cell in to percen
You're welcome. Thanks for the feedback.
Regards, Fred. "Andy" wrote in message ... Thank you! Thank you! Thank you! That was just what I was looking for. You are awsome. -- Thank you for your help Andy B. "Fred Smith" wrote: You either want an If statement, or a Vlookup table. Try something like: =if(a1="Commercial",20%,10%) Regards Fred "Andy" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
