Best Answer

Related Post

Spread the word

Digg this post

Bookmark to delicious

Stumble the post

Add to your technorati favourite

Subscribes to this post

3 Comments Already

Puzzling Said,
January 29th, 2011 @3:40 pm  

Put a number into A1 representing the time (say 0 hours).

Put the following formula into B1 representing the distance:

You can create a table of values by copying the cells down to later rows. Change the value in the first column (A) and column B should be recalculated automatically.

0 0
1 45
2 90
3 135
4 180

Dave Said,
January 29th, 2011 @4:27 pm  

Just put in =45*(how many hours). The result that appears is the distance.

beartalon Said,
January 29th, 2011 @4:45 pm  

Since the speed stays the same, use one column for time, and one for distance.

In the time column, put the values you’ll test: 0, 1, 2, 3, 4 …
In the distance colum put the formula =45*[timecolumncell]
[timecolumncell is the cell reference for the matching time cell.

Then the distance column will have the distance for each time at 45 mph.

Leave Your Comments Below

Please Note: All comments will be hand modified by our authors so any unsuitable comments will be removed and you comments will be appreared after approved