Need help with formula

[Jaymes1995]

Hello.

I am sure this is a simple problem. Formula to multiply part of the cell value, based on range, by a different %.  Please see a simple example below.

Cell value: $100,000

Column A

Row 1:  If cell value is between $0 to 10,000, 8%.
Row 2: If cell value is between $10,001 to 15,000, 10%.
Row 3:  If cell value is $15,0001 to 20,000, 15%.
Row 4:  If cell value is $20,001 to 25,000, 20%

[#2]

@Jaymes1995 

With such helper range

formula could be

=SUMPRODUCT((IF($A$2>$E$2:$E$5,$E$2:$E$5,$A$2)-$D$2:$D$5+1)*($A$2>$D$2:$D$5)*$F$2:$F$5)

[#3]

@Sergei Baklan 

Thank you my friend.  This is all I needed to get me started.  Cheers. 

[#4]

@Jaymes1995 , you are welcome