hi all, i am not familar with this function however my reading up here and other forums suggest that it might work for what i want, would really appreciate any help. from the below table, if volume = 2549 then charge =2549 * 2.50, will sumproduct work in this instance, if not can you suggest any other function. my first array in the sumproduct is A9<($C$2:$C$6) and i see false, false, true, true, true. i am stuck with the second array to identify 2.5 and then multiply 2549 by 2.50. hope this is clear
From To charge
0 500 3.50
501 999 3.00
1000 2999 2.50
3000 4999 2.00
5000 999999999 1.50

amount to be charged = 2549, let say in A9 ,
=SUMPRODUCT(A9<$C$2:$C$6) ....