Im creating a mileage sheet for my company and am having a bit of a time writing a formula. Heres my issue...
Column C is beginning mileage, D is ending mileage, E is business miles driven, F personal miles driven and G the total miles driven.
I have a formula in cell G10 to calculate the total miles driven for the day...=IF(OR(ISBLANK(D10),ISBLANK(C10)),"",D10-C10)
Simple right? My problem is that I need also make sure that columns E+F equal Column G for their respective cells. This is to make sure that business miles and personal miles equal the total miles driven for the day and minimize any inadvertent errors in being entered.
For some reason, I cant figure this one out. I've racked my brain for a good couple days with many error messages along the way.
Any help would be greatly appreciated!
Cheers and thanks....
Bookmarks