Multiple condition in sales commission table

[Dsunil05]

<tbody>
[TD="class: xl66"]SAVING A/C[/TD]
[TD="class: xl66"]COMISSION AMOUNT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]FD A/C[/TD]
[TD="class: xl66"]COMISSION AMOUNT[/TD]

[TD="class: xl66"]10[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]10[/TD]
[TD="class: xl66"]0[/TD]

[TD="class: xl66"]25[/TD]
[TD="class: xl66"]400[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]25[/TD]
[TD="class: xl66"]400[/TD]

[TD="class: xl66"]35[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]35[/TD]
[TD="class: xl66"]0[/TD]

[TD="class: xl66"]50[/TD]
[TD="class: xl66"]400[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]50[/TD]
[TD="class: xl66"]900[/TD]

[TD="class: xl66"]65[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]65[/TD]
[TD="class: xl66"]0[/TD]

[TD="class: xl66"]70[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]70[/TD]
[TD="class: xl66"]0[/TD]

[TD="class: xl66"]75[/TD]
[TD="class: xl66"]400[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]75[/TD]
[TD="class: xl66"]1500[/TD]

</tbody>

THIS SALE COMMISSION TABLE OF BANK

1.) IN FIRST TABLE HOW COMMISSION REFLECT SAME IN "COMMISSION AMOUNT COLUMN" WHEN A/C COMES IN MULTIPLE OF 25 ( OR ANY OTHER MULTIPLE OF NUMBER)
I TRIED THIS FOR "B" COLUMN = IF (A3/25>=1,400,0)
BUT B4 TO B8 SHOWING 400


2.)IN SECOND TABLE HOW COMMISSION REFLECT DIFFERENT IN "COMMISSION AMOUNT COLUMN" WHEN A/C COMES IN MULTIPLE OF 25 ( OR ANY NUMBER)

IN SECOND TABLE EVERY TIME CHANGE COMMISSION AMOUNT WHEN FD A/C COMES IN MULTIPLE OF 25 ( OR ANY OTHER MULTIPLE OF NUMBER)

WHAT TO DO?

GUIDE ME WITHOUT USING VBA / MACRO I AM USING MS EXCEL 2007

 

[Eric W]

Try:

	A	B	C	D	E

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]SAVING A/C[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]COMISSION AMOUNT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]FD A/C[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]COMISSION AMOUNT[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]35[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]35[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]900[/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]65[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]65[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]70[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]70[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]75[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]75[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1400[/TD]

</tbody>

Sheet11​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=IF(MOD(A2,25)=0,400,0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=IF(MOD(D2,25)=0,400+(INT(D2/25)-1)*500,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



To check to see if a number is a multiple of 25, use MOD. MOD returns the remainder when you divide by 25 (or some other number), so when the remainder is 0, it's a multiple. For the second formula, I don't know how you intend to change the amounts, so the formula I created starts at 400 and adds 500 each time. It doesn't match your example, so if you have a different method, let me know and I'll adapt it.

 

[jtakw]

Hi,

This is my take on it.

Please note Column E commission is not linear.

Book1
	A	B	C	D	E	F
1	SAVING A/C	COMISSION AMOUNT		FD A/C	COMISSION AMOUNT	COMISSION AMOUNT
2	10	0		10	0	0
3	25	400		25	400	400
4	35	0		35	0	0
5	50	400		50	900	900
6	65	0		65	0	0
7	70	0		70	0	0
8	75	400		75	1500	1500
Sheet118

Cell Formulas
Range	Formula
E2	=IF(MOD(D2,25),0,CHOOSE(D2/25,400,900,1500))
F2	=IF(MOD(D2,25),0,400*(D2/25)+100*CHOOSE(D2/25,0,1,3))
B2	=IF(MOD(A2,25),0,400)

Formulas copied down.

 

[Dsunil05]

sorry sir it is if in single month saving A/C OR FD ACCOUNT CROSSING 25 (e.g. 28 , 32, 39.....49) means greater than 25 and less than 49 ,then its not working

 

[jtakw]

sorry sir it is if in single month saving A/C OR FD ACCOUNT CROSSING 25 (e.g. 28 , 32, 39.....49) means greater than 25 and less than 49 ,then its not working

I do not understand what you're saying at all.

Please explain clearly, and may be also post detailed samples with expected results.

 

[Dsunil05]

[TABLE="width: 342"]
<tbody>[TR]
[TD="align: center"]MONTH
[/TD]
[TD="align: center"]SAVING A/C[/TD]
[TD="align: center"]TOTAL[/TD]
[TD="align: center"]CARRY FORWORD[/TD]
[TD="align: center"]COMISSION AMOUNT[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]800
[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]1200[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]1200[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]1200[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]

MEANS IN
1ST MONTH NEW 10 A/C, TOTAL A/C= 10, COMMISSION =00, QUALIFY A/c=00, REMAIN FOREWORD TO NEXT MONTH=10 A/C
2ND MONTH NEW 25 A/C , TOTAL A/C= 35, COMMISSION =400, QUALIFY A/c=25, REMAIN FOREWORD TO NEXT MONTH=10 A/C
3RD MONTH NEW 35 A/C , TOTAL A/C=45 (LAST MONTH REMAIN 10+), COMMISSION =400, QUALIFY A/c=25, REMAIN FOREWORD TO NEXT MONTH=20 A/C
4TH MONTH NEW 50 A/C , TOTAL A/C=70 (LAST MONTH REMAIN 20+), COMMISSION =800, QUALIFY A/c=50, REMAIN FOREWORD TO NEXT MONTH=20 A/C
5TH MONTH NEW 65 A/C , TOTAL A/C=85 (LAST MONTH REMAIN 20+), COMMISSION =1200, QUALIFY A/c=75, REMAIN FOREWORD TO NEXT MONTH=10 A/C
6TH MONTH NEW 70 A/C , TOTAL A/C=80 (LAST MONTH REMAIN 10+), COMMISSION =1200, QUALIFY A/c=75, REMAIN FOREWORD TO NEXT MONTH=05 A/C
7TH MONTH NEW 75 A/C , TOTAL A/C=80 (LAST MONTH REMAIN 5+), COMMISSION =1200, QUALIFY A/c=75, REMAIN FOREWORD TO NEXT MONTH=05 A/C
8TH MONTH NEW 15 A/C , TOTAL A/C=20 (LAST MONTH REMAIN 5+), COMMISSION =00, QUALIFY A/c=00, REMAIN FOREWORD TO NEXT MONTH=20 A/C

SAME FOR F/D ACCOUNT BUT COMMISSION SLAB IS DIFF

 

[jtakw]

Thank you for providing Clear details, it's quite a bit different than what I understand from you OP.

I believe this will work for this part of your query.

I'm providing formulas for "TOTAL", "CARRY FORWARD", and "COMMISSION AMOUNT", if you Only need "COMMISSION AMOUNT", then disregard Column C and D formulas, and use Only Column E formula.

All formulas copied down.

Book1
	A	B	C	D	E
1	MONTH	SAVING A/C	TOTAL	CARRY FORWORD	COMISSION AMOUNT
2	1	10	10	10	0
3	2	25	35	10	400
4	3	35	45	20	400
5	4	50	70	20	800
6	5	65	85	10	1200
7	6	70	80	5	1200
8	7	75	80	5	1200
9	8	15	20	20	0
Sheet118

Cell Formulas
Range	Formula
C2	=SUM(D1,B2)
D2	=C2-INT(C2/25)*25
E2	=INT(C2/25)*400

 

[Dsunil05]

THANKS ALL DONE WITH SAVING A/C

BUT WITH FD A/C BONUS GIVEN BELOW

[TABLE="width: 574"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]MONTH[/TD]
[TD]FD A/C[/TD]
[TD]TOTAL[/TD]
[TD]CARRY FORWORD[/TD]
[TD]COMISSION AMOUNT[/TD]
[TD]BONUS AMOUNT[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]0.00[/TD]
[TD]400.00[/TD]
[TD]10000.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]250[/TD]
[TD]250[/TD]
[TD]0.00[/TD]
[TD]4000.00[/TD]
[TD]20000.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1250[/TD]
[TD]1250[/TD]
[TD]0.00[/TD]
[TD]20000.00[/TD]
[TD]40000.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[TD]0.00[/TD]
[TD]80000.00[/TD]
[TD]80000.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]20000[/TD]
[TD]20000[/TD]
[TD]0.00[/TD]
[TD]320000.00[/TD]
[TD]160000.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]80000[/TD]
[TD]80000[/TD]
[TD]0.00[/TD]
[TD]1280000.00[/TD]
[TD]320000.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]32000[/TD]
[TD]32000[/TD]
[TD]0.00[/TD]
[TD]5120000.00[/TD]
[TD]640000.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]96000[/TD]
[TD]96000[/TD]
[TD]0.00[/TD]
[TD]15360000.00[/TD]
[TD]1280000.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]288000[/TD]
[TD]288000[/TD]
[TD]0.00[/TD]
[TD]46080000.00[/TD]
[TD]2560000.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]576000[/TD]
[TD]576000[/TD]
[TD]0.00[/TD]
[TD]92160000.00[/TD]
[TD]7680000.00[/TD]
[/TR]
</tbody>[/TABLE]

BONUS FOR EVERY SALESMEN SINGLE TIME IN ALL JOB TIME

[TABLE="width: 489"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]FD A/C NOS SLAB[/TD]
[TD]NO OF FD A/C FROM[/TD]
[TD]NO OF FD A/C TO[/TD]
[TD]SLAB BONUS AMOUNT[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]25[/TD]
[TD]249[/TD]
[TD]10000.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]250[/TD]
[TD]1249[/TD]
[TD]20000.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1250[/TD]
[TD]4999[/TD]
[TD]40000.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5000[/TD]
[TD]19999[/TD]
[TD]80000.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]20000[/TD]
[TD]79999[/TD]
[TD]160000.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]80000[/TD]
[TD]31999[/TD]
[TD]320000.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]32000[/TD]
[TD]95999[/TD]
[TD]640000.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]96000[/TD]
[TD]287999[/TD]
[TD]1280000.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]288000[/TD]
[TD]575999[/TD]
[TD]2560000.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]576000[/TD]
[TD]AND ABOVE[/TD]
[TD]7680000.00[/TD]
[/TR]
</tbody>[/TABLE]

HOW TO DO?

 

[jtakw]

Please re-check your figures:

Table 1:
Line 7, 8, 9, 10, "Commission Amount" do Not seem to be correct.

Table 2:
Line 7, 8, Columns "From" and "To", went Backwards?

 

[Dsunil05]

yes my mistake,

[TABLE="width: 489"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]FD A/C NOS SLAB[/TD]
[TD]NO OF FD A/C FROM[/TD]
[TD]NO OF FD A/C TO[/TD]
[TD]SLAB BONUS AMOUNT[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]25[/TD]
[TD]249[/TD]
[TD]10000.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]250[/TD]
[TD]1249[/TD]
[TD]20000.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1250[/TD]
[TD]4999[/TD]
[TD]40000.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5000[/TD]
[TD]19999[/TD]
[TD]80000.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]20000[/TD]
[TD]79999[/TD]
[TD]160000.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]80000[/TD]
[TD]319999[/TD]
[TD]320000.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]320000[/TD]
[TD]959999[/TD]
[TD]640000.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]960000[/TD]
[TD]2879999[/TD]
[TD]1280000.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2880000[/TD]
[TD]5759999[/TD]
[TD]2560000.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]5760000[/TD]
[TD]AND ABOVE[/TD]
[TD]7680000.00[/TD]
[/TR]
</tbody>[/TABLE]