Need help with formula/function that calculates total until value reached

[redcougar78]

First of all thank you in advance for reading this and providing any and all help to this newbie. I am using Excel 2010 and am working on a commission tracking sheet for my company. What I am having trouble with is this: we have a tiered pay out system, that increases every 25 points you get, 0-25 = $10/point, 26-50 = $15/point, 51-75=$20/point, 76-100=$25/point and 101+=$30/point. I need a running total that will count every 25 points then carries over in the next column over. This how I have it set up right now, I hope it explains things clear enough.


A1 Daily Points B Column C Column
points 0-25 points 26-50
$10.00 $15.00
25 26
$250.00 $15.00