In Between IF AND Excel Formula HELP

[avargas232]

I'm not really too sure how to word this, and I think I'm burnt out from looking at it...so I may be overthinking it. I currently have a formula that is sufficient enough, but I want to take it another level and I just can't figure it out.

My current formula is IF(I6="","",IF(AND(I6>=D6,I6<E6),B6*D$4,IF(AND(I6>=E6,I6<F6),B6*E$4,IF(AND(I6>=F6,I6<G6),B6*F$4,IF(I6>=G6,B6*G$4,IF(I6<D6,0,""))))))

Here is an example of the file:

https://www.dropbox.com/s/rjrymog7f636jza/Percent%20Calc.xlsx?dl=0

and also in cell J12 is the output I'd like.

Hope someone can help...thanks!!!

 

[avargas232]

I may have a solution as well. I will test yours out and see if it works. Thank you so much...I'll let you know how it goes!