Excel 2007 : Repeating Formula

Hi Again,

I am using this formula and it works but i need it follow the same pattern you can see below.

Is there an easier way to follow the same pattern without having the formula this long?

=IF(AND(C6>=J12,C6<J13),K12*C7,IF(AND(C6>=J13,C6<J14),K13*C7,IF(AND(C6>=J14,C6<J15),K14*C7,IF(AND(C6>=J15,C6<J16),K15*C7,IF(AND(C6>=J16,C6<J17),K16*C7,IF(AND(C6>=J16,C6<J17),K17*C7,IF(AND(C6>=J17,C6<J18),K18*C7,
)))))))

i still have many cells to cover using the same formula.


Thanks.

Mick