|okay, I have been trying to figure this out and I am at my wit's end; CHOULD SOMEONE HELP ME PLEASE??|
This is what I need done:
miles price is different for certain amount of miles;
1-5 miles is 7.
6-10 miles is 5.5
11-15 miles is 4.
and 16 -19 miles is 2.5
My driver took a product of the travel distance of 16 miles which is milage pay of 2.5
but the next delivery that was done is 6, than 8, and so forth. Each time it is different.
I figured out that this formula should work for what I need, but it will not compute the anser without me having to search and manually put it in.
The formula that I can up with is:
with line 33 being 1-5 miles is 7.
line 34 being 6-10 miles is 5.5
line 35 being 11-15 miles is 4.
and line 35 being 16 -19 miles is 2.5
H42 is the milage
Does anoyone have an idea how to make it work with the EXCEL PROGRAM?