this looks like a good setup fpr a index match

set up a table with first column =A4,=A3,=A2,0

second column (
N5-$A$4)*$D$5+$F$4,(N5-$A$3)*$D$4+$F$3,(N5-$A$2)*$D$3+$F$2,N5*$D$2

note this is inverted order to go with the less than or equal to aspect
=index(second_column_new_table_range,match(N5,firs t_column_new_table_range,-1))



"Anna" wrote:

I am trying to calculate commission amount based on different gross sales
with different %s paying on increments. Also want to be able to change gross
sales variables and %s.

Example
=IF(N5<=$A$2,N5*$D$2,IF(N5<=$A$3,(N5-$A$2)*$D$3+$F$2,IF(N5<=$A$4,(N5-$A$3)*$D$4+$F$3,IF(N5<=$A$5,(N5-$A$4)*$D$5+$F$4))))

Meaning - N5=gross sales; $A=sales increment; $D=%; $F=previous calc. added

Of course, I can only put 8 if statements in the formula. How else can this
be calculated with more variables?
--
Anna