Originally Posted by Anonymously_Unknown
I do this too. The issue is that I sometimes find it annoying to keep adding new rows each time I need to make a new entry.
The only column that needs a formula is the one that actually calculates the MPG. I use a formula there that keeps the values hidden until I fill in the date (avoids the zero or "/div!" coming up when there are no values). Then I simply copy that formula down for a hundred rows or so. Thus I only have to fill in the next date - not add rows.
This is formula for the MPG column:
The "A" column contains the dates, the "B" column contains the miles driven, and the "C" column contains the gallons put into the tank.
Phone: HTC One M8 T-Mobile, Stock ROM KitKat
Tablets: Lenovo IdeaPad A2019 9" Tablet / ICS | Dell Venue 7" Tablet / JB
Laptop: Toshiba Satellite T925u / Windows 8.1
Former Phones: Ericsson T-28, Ericsson R600 World, T-Mobile Windows Phone, HP 6310, Sony-Ericsson M600, HTC Pharos, Asus P527, HTC Tilt2, HTC HD2, HTC Amaze, HTC M7