One way:

Put your descriptions and rates in a table, perhaps on a separate sheet
(say, Sheet2):

A B

1 Description Rate
2 Digital Printer 7.79%
2 Professional Photogr 11.79%
3 Exhibit House 7.79%
4 ...


Then in column C in sheet1, enter

=A1*VLOOKUP(B1,Sheet2!A:B,2,FALSE)



In article ,
"Pete Petersen" wrote:

I really appreciate your help with this but it gets a liitle more complex.

Here is the breakdown:

We have more than 2 market segments that will base our commissions.

Let's take this example:

Column A Column B
$(65.60) Digital Printer
$(69.35) Professional Photogr
$(29.16) Professional Photogr
$(152.48) Digital Printer
$(306.00) Digital Printer
$(95.90) Digital Printer
$(40.00) Professional Photog
$(110.42) Exhibit House
$(110.42) Exhibit House
$(23.74) Professional Photogr
$(99.50) Digital Printer
$(29.16) Professional Photogr
$(26.74) Professional Photogr
$(153.00) Digital Printer
$(29.16) Professional Photogr
$(63.75) Digital Printer
$(69.50) Digital Printer
$(35.98) Digital Printer
$(93.60) Digital Printer

I want to be able to use the following:
Digital Printer = .0779
Professional Photogr = .1179
Exhibit House = .0779

There are a couple levels of commission...I want to be able to say if Column
B = one the above statements then multiple my Colomn A by the rates stated
above.

Thank you for help in this issue.
Pete Petersen