Update based on your clarification:
Use B1:F1 to enter the codes y or n (Excel will not care if you use upper or
lower case)
In A2 enter the order amount
In B2 use something like =IF(B1="Y",A2*(100%-15%),A2)
In C1 =IF(C1="Y",B2*20%,B2*10%)
In D2 =IF(D1="Y",B2*2%,0)
In E2 =IF(E1="Y",B2*2%,0)
In F2 =IF(F1="Y",B2*1%,0)
In G2 =SUM(C2:F2)

If you have a column of A's starting in A5:
Use column H for code, so in example enter yyyyy or YYYYY
A5 1000
B5 =IF(MID($H5,1,1)="Y",A5*(100%-15%),A5)
C5 =IF(MID($H5,2,1)="Y",$B5*20%,$B5*10%)
D5 =IF(MID($H5,3,1)="Y",$B5*2%,0)
E5 =IF(MID($H5,4,1)="Y",$B5*2%,0)
F5 =IF(MID($H5,3,1)="Y",$B5*1%,0)
G5 =SUM(C5:F5)
copy B5:F5 down and fill in values for A and H


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
I cannot see how you compute $212.50
Bur here is a start, assuming you are finding commission on only one
amount.
Use B1:F1 to enter the codes y or n (Excel will not care if you use upper
or lower case)
In A2 enter the order amount
In B2 use something like =IF(B1="Y",A2*(100%-15%),A2) (looks like $850
already!)
In C1 =IF(C1="Y",B2*20%,B2*10%)
etc
I you clarify the method, I will refine the answer
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Oriana G" <Oriana wrote in message
...
Here's my problem, I'm trying to create a worksheet to calculate our
commsiion structure, but can't figure out a way to attack it. We have
many
variables (5) in our commission structure based on each order. Here's how
I
set it up so far:

(In Cloumns)
A= Order Amount
B= "Y" is A-15%; "N"=A
C= "Y" is B*20%; "N" is B*10%
D= "Y" is B+2%; "N" is B
E= "Y" is B+2%; "N" is B
F="Y" is B+1%; "N" is B
G= SUM(A:F)

For example, if the order is $1000, and I answer y,y,y,y,y=$212.5

How do I create the formulas so I can just put in the order amount and
the
appropriate letter to get the correct commission structure?