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


"Frank Kabel" wrote:

Hi
in D1:
=A1*IF(B1="Digital",0.08,0.11)

if you only have these two segments

--
Regards
Frank Kabel
Frankfurt, Germany

"Pete Petersen" <Pete schrieb im
Newsbeitrag ...
Here is the issue:

Margin Market Seg Cust Seg Commission
50.00 Digital A ?
32.00 Professional E ?
50.00 Digital B ?
42.00 Professional D ?

I want to be able to say: If Market Seg = Digital then Multiple
Margin by
.008
If Market Seg = Professional
then
Multiple Margin by .011

How can I Do this and how?