Formula that will change a text that is in a cell in to percentage

[Andy]

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%.

 

[Fred Smith]

You either want an If statement, or a Vlookup table.

Try something like:
=if(a1="Commercial",20%,10%)

Regards
Fred

 

[Andy]

Thank you! Thank you! Thank you! That was just what I was looking for. You
are awsome.
--
Thank you for your help
Andy B.

You either want an If statement, or a Vlookup table.

Try something like:
=if(a1="Commercial",20%,10%)

Regards
Fred

 

[Fred Smith]

You're welcome. Thanks for the feedback.

Regards,
Fred.

Thank you! Thank you! Thank you! That was just what I was looking for. You
are awsome.