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!