There are 8 cities in the country of Eight, A, B, C, D, E, F, G and H. Mr. Z decides to visit each city in his car starting from A. His planned itinerary is A-->B-->C-->D-->E-->F-->G-->H. The distance between the cities is given in Table I |
<tbody>
</tbody>
Table I | ||||||||||||||||||||
Distance | ||||||||||||||||||||
A | B | C | D | E | F | G | H | |||||||||||||
A | 0 | 200 | 0 | |||||||||||||||||
B | 200 | 0 | 350 | 200 | ||||||||||||||||
C | 350 | 0 | 500 | 550 | ||||||||||||||||
D | 500 | 0 | 250 | 1050 | ||||||||||||||||
E | 250 | 0 | 850 | 1300 | ||||||||||||||||
F | 850 | 0 | 1250 | 2150 | ||||||||||||||||
G | 1250 | 0 | 150 | 3400 | ||||||||||||||||
H | 150 | 0 | 3550 | |||||||||||||||||
Write a formula which takes the number of kms that Mr. Z has travelled from A as the input and displays the name of the city which is nearest to that point. Mr. Z will enter the number of kms he has travelled from A in cell D30 and the name of the city nearest to the point will be displayed in E30 | ||||||||||||||||||||
<tbody>
</tbody>
Number of Kms that Mr. Z has travelled | Nearest City | |||||||||
<tbody>
</tbody>