- Engineering
- Computer Science
- 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
