1. Engineering
  2. Computer Science
  3. using the distances between us cities given in a file...

Question: using the distances between us cities given in a file...

Question details

Using the distances between US cities given in a file (Make up data), write a formula using the MATCH function to determine (based on the names of the cities) the distance between any two of the cities.

A file (make up data) gives the amount of time between bus arrivals (in minutes) at 45th Street and Park Avenue in New York City. Write a formula that, for any arrival time after the first bus, gives the amount of time you have to wait for a bus. For example, if you arrive 12.4 minutes from now, and buses arrive 5 minutes and 21 minutes from now, you wait 21–12.4=8.6 minutes for a bus.

USE EXCEL

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution