Hi everyone. I'm horrible with math and am very rusty at Excel. I apologize in advance for asking such an easy question and my ignorance.
I'm using Excel '07 and trying to compute the monthly cost of my drive to work.
The problem is that I need to change the distance traveled per computation. I have about 4 sheets that utilize different distances. The distance is placed in cell B4 on each sheet.
So, this is what I've come up with but I can't seem to create an Excel formula. Any help will be greatly welcomed.
Distance is X (let's say 32 miles for example). Gas is $2.70 per gallon. My car gets 30 mpg. I use 2-4 gallons per day.
First, I'd calculate the daily amount then the amount of days traveled within the month to calculate the monthly cost.
So, this is what I worked out in my addled brain:
However, I come out with a total of over $3,000. What am I doing wrong? What would the correct formula be?
Thank you for any help. I'll greatly, greatly appreciate it.
I'm using Excel '07 and trying to compute the monthly cost of my drive to work.
The problem is that I need to change the distance traveled per computation. I have about 4 sheets that utilize different distances. The distance is placed in cell B4 on each sheet.
So, this is what I've come up with but I can't seem to create an Excel formula. Any help will be greatly welcomed.
Distance is X (let's say 32 miles for example). Gas is $2.70 per gallon. My car gets 30 mpg. I use 2-4 gallons per day.
First, I'd calculate the daily amount then the amount of days traveled within the month to calculate the monthly cost.
So, this is what I worked out in my addled brain:
Code:
=B4(2.7*2)*21.5 (the number of days driven to work)
However, I come out with a total of over $3,000. What am I doing wrong? What would the correct formula be?
Thank you for any help. I'll greatly, greatly appreciate it.