gingerstyles

New Member
Joined
Oct 18, 2017
Messages
3
Hey guys...

How do you compute the total distance traveled by two drivers if you have the trip distance as well as the the rate per km:)
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
does each driver submit a trip distance

or does second driver take over lorry after say 150 miles and second driver is paid 50% more than the first driver ?
 
Upvote 0
Each driver submits a trip disatance..say 1st driver Bmw 100kms, 2nd one benz 150kms. The rates 1st driver 15 per km and 2nd one 15.50 per km
 
Upvote 0
Each driver submits a trip disatance..say 1st driver Bmw 100kms, 2nd one benz 150kms. The rates 1st driver 15 per km and 2nd one 15.50 per km
You started by asking "how do you compute the total distance traveled" and are now giving us the distances and maybe asking for total cost? Given that, your ultimate question is not very clear making this sound like a homework assignment to me.
 
Upvote 0
first driver 100*15
second driver 150*15.50

just add the two totals to get total cost - if that is the question

maybe put entire question on here and we can tell you the approach to take
 
Upvote 0
Have to agree with Rick Rothstein.
Sounds like the sort trick questions some of my teachers used to hand out.
 
Upvote 0
so give us the full question and we will tell you a best generic approach, so you "learn", and at no charge !!!!
 
Upvote 0

Forum statistics

Threads
1,216,038
Messages
6,128,447
Members
449,453
Latest member
jayeshw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top