Formula entry for division of columns in multiple rows
I'm relative new to Excel having just used it as a lined sheet of paper for listing things.
I'm trying to develop an Excel spreadsheet for tracking my car's mileage. Thus far I'm using a basic sheet with 4 columns - designated A=date, B=Miles travelled, C= Gallons used, and D= the computed MPG when B is divided by C.
Is there anyway to enter a formula that will do that to each row automatically, without me having to enter for column D, each row, the formula "=b2/c2" and "b3/c3", and "b4/c4", and so on.. Thus far, all I can figure out is that I have to type in the formula for each row.
Also, I'd like to have a side display that keeps an easily-viewed running tally of two values, the lowest MPG and highest MPG values.
Does anyone know how this can be done relatively easily?
|