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 D:D by calculating the distance between each city and the next city in the list.
Place your calculation in cell D
Use the INDEX function.
Note that you will not calculate a distance in cell D since there is not a city below it on the list.
Reference the city distance lookup table range C:N in your formula.
The position of each city is included next to the name of that city in range B:B and should be referenced in your formula.
Reuse your formula to complete the distance calculations in range D:D
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
