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.

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.

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.

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.