Hello,
I am trying to use a formula for drivers pay where the rate of pay will vary depending on the length of the trip.
For example between 0 and 300 miles pays $0.70 per mile, and $30.00 per delivery, where as a trip between 301 and 625 miles will pay $0.65 per mile and $25.00 per delivery.
I want to be able to just enter the millage and deliveries and have the formula figure it out. One cell for millage and one for deliveries.
Thanks.
Bookmarks