hI,.

=SUMPRODUCT(--(A1{0;5;30;60}),A1-{0;5;30;60},{0;2.15;0.1;-0.15})

"Clinton Spry" wrote:

I need to know how to put in a formula that will let me calculate something
like this.
0 to 5 miles $0
next 25 miles is $2.15 each
next 30 miles is 2.25 each
next 40 miles is 2.10 each
for a total of 100 miles
so if i entered 100 miles it would calculate the first 5 at 0$ then the next
25 at $2.15
then the next 30 at $2.25 then the next 40 at $2.10. for a total of 100
miles and display the correct dollar amount. but if i entered 65 miles it
would calculate the first 5 at 0$ then the next 25 at 2.15 then the next 30
at 2.25 then the next 5 at 2.10 for a total of 65 miles and give the correct
dollar amount.
Thanks Clint.