Microsoft Excel Question

mdart · 06-29-2009, 03:57 PM

I'm creating a mileage log and want to enter the total miles for the day and have the spreadsheet calculate the beginning and ending mileage. Can you tell me what formula to use so I can copy the formula for the whole year?

Example:

Jan 1st 57 miles beg - 32,500 ending - 32,557
Jan 2nd 30 miles beg - 32,557 ending - 32,587

Thanks for the help!

**macropod** · 06-30-2009, 05:11 AM

Hi mdart,

It's not clear from your post how the data are laid out (ie which parts are in a given column). If you could explain that, you'll have a better chance of being helped.

mdart · 06-30-2009, 08:39 AM

Okay, sorry that was not clear...here are the columns

Date------miles per day----beginning miles---ending miles

Jan 1st------57 miles----------32,500---------32,557

Jan 2nd------30 miles----------32,557---------32,587

mdart · 06-30-2009, 09:26 AM

I figured it out...Thanks

06-29-2009, 03:57 PM	#1 (permalink)
mdart Registered User Join Date: Jun 2009 Posts: 3 OS: vista	Microsoft Excel Question I'm creating a mileage log and want to enter the total miles for the day and have the spreadsheet calculate the beginning and ending mileage. Can you tell me what formula to use so I can copy the formula for the whole year? Example: Jan 1st 57 miles beg - 32,500 ending - 32,557 Jan 2nd 30 miles beg - 32,557 ending - 32,587 Thanks for the help!

06-30-2009, 05:11 AM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 559 OS: Vista	Re: Microsoft Excel Question Hi mdart, It's not clear from your post how the data are laid out (ie which parts are in a given column). If you could explain that, you'll have a better chance of being helped. __________________ Cheers macropod (MS MVP -Word)

06-30-2009, 08:39 AM	#3 (permalink)
mdart Registered User Join Date: Jun 2009 Posts: 3 OS: vista	Re: Microsoft Excel Question Okay, sorry that was not clear...here are the columns Date------miles per day----beginning miles---ending miles Jan 1st------57 miles----------32,500---------32,557 Jan 2nd------30 miles----------32,557---------32,587

06-30-2009, 09:26 AM	#4 (permalink)
mdart Registered User Join Date: Jun 2009 Posts: 3 OS: vista	Re: Microsoft Excel Question I figured it out...Thanks