Pages

Wednesday, November 3, 2010

Calculate the average speed - Formulas In Excel - Microsoft Excel Tutorials



36.  Calculate the average speed

In this example, someone travels from New York to Los Angeles with an average speed of 90 miles per hour. On the way back, the average speed is 75 miles per hour. What is the overall average speed?

To calculate the average speed, the speed in each direction has to be taken into consideration.

To calculate the overall average speed:

1. In cell C2, enter 90.
2. In cell C3, enter 75.
3. In cell C4, type the following formula: =(C2+C3)/2.





Watch the Video Tutorial - https://www.youtube.com/watch?v=NiSfJAtMSfg

  Hope You Like This Tutorial - Give Comments

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews