sample fuel.xlsx
i would like to have an excel file that calculates my car's <litres/100km> and <average litre per 100km>. i have been keying in the formula manually.
1. are the formulas correct
2. is there a way to fill in the formula automatically using fill series or something like that?
3. i dont have the data for <litres filled> in E2 which screws up my numbers. what can i do to overcome that?
thanks
Hi and welcome to the forum
Try these, copied down....
D3=IF(C3="","",C3-C2)
F3=IF(D3="","",E3*100/D3)
G3=IF(C3="","",SUM($E$2:E3)/SUM($D$2:D3)*100)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
sorry but which formulas go into cells F2 and G2?
The answer you have in D2 does not make sense, but you can leave it as is
the F3 and G3 you can copy up
sorry i didnt explain at the start... when i got the car it had already had some kms done on the odometer. thats why D2 is strange. also i didnt record "litres filled" for the 1st time which was a mistake on my part. here is an updated file with what i estimate those cells should be.
sample fuel2.xlsx
please note columns A,B,C,D and E are data, not calculations. each time i fill at the pump, i key in the "date", "odometer" reading, the trip meter which tells me the "km travelled" since the last fill, and the "litres filled" into the tank. from that data, i want to calculate column F and G
aah now i get it! thanks a million FDibbins!!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks