Ok, I'm dumb...how do I enter the codes for Y and N in b1:f1?

"Bernard Liengme" wrote:

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?