IF Function with monetary ranges - Commissions

I will use "C2" as the cell that is always used in this question

if c2 = $50,000-$54,999, then $200
if c2 = $55,000-$59,999, then $300
if c2 = $60,000-$64,999, then $400

Basically base is $50,000 = $200
for every additional $5000 you get an additional $100

Thanks for your help!

how about

Excel 2013 32 bit

	C	D	E
2	49000	200	=MAX(200+INT((C2-50000)/5000)*100,200)
3	51000	200
4	59999	300
5	60000	400
6	63000	400
7	70000	600

Sheet: Orders

I tried to post a formula but it said HTML code not allowed.

That did not work for me.
Here is a diagram of what I mean

sales commission if sales were $69,805, then the commission would be $500.00
$50,000 $200.00
$55,000 $300.00
$60,000 $400.00
$65,000 $500.00
$70,000 $600.00
$75,000 $700.00

So my idea if a cell is equal to $69,805, then the equation will auto populate $500.00

That's exactly what that formula does

Excel 2013 32 bit

	C	D
2	69805	500
3	119689	1500
4	50000	200
5	55000	300
6	60000	400
7	65000	500
8	70000	600
9	75000	700
10	80000	800
11	85000	900
12	90000	1000
13	95000	1100
14	100000	1200
15	105000	1300
16	110000	1400
17	115000	1500
18	120000	1600
19	125000	1700
20	130000	1800
21	135000	1900
22	140000	2000

Sheet: Orders

OMG guys....it works! I don't know what I did last time but it is AWESOME!!! Thank you guys Fluff13...you are great

Glad we could help & thanks for the feedback