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?