I need to have Excel calculate percentages of a cell based on where it falls
between numbers...for example:


Percentage of this number: (B2) $3,500.00

0 - 2500 = 25% $0.00 (B4)
2501 - 3500 = 30% $0.00 (B5)
3501 + = 35% $0.00 (B6)

So if B2 were $4000.00 the calculations should equal out to as follows:
2500 * 25% = 625
1000 * 30% = 300
500 x 35% = 175

Can this be done? I tried SUMIF, IF(AND), and stuff like that but nothing
seems to come out right.

Please help!