Question: Complete range D 3 :D 9 by calculating the distance between each city and the next city in the list. Place your calculation in cell

Complete range D3:D9 by calculating the distance between each city and the next city in the list.
Place your calculation in cell D3.
Use the INDEX function.
Note that you will not calculate a distance in cell D10 since there is not a city below it on the list.
Reference the city distance lookup table (range C20:N31) in your formula.
The position of each city is included next to the name of that city in range B3:B9 and should be referenced in your formula.
Reuse your formula to complete the distance calculations in range D3:D9.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!