Hi there, please excuse me as I'm newbie for excel formulas. I'm trying to create a mileage calculation chart.

E12= Starting Odometer
F12= Ending Odometer

B12= "Home" or "Office"
B7= Mile Value
G12= Result value

Basically I'm trying to accomplish F12-E12 and if B12 = Home, subtract B7.

I have this but not sure where is wrong as Im editing an existing formula:
=IF(OR(ISBLANK(E12),ISBLANK(F12),0,F12-E12,IF(B12="Home",-B7)))

Hiroshi

try this
=IF(OR(ISBLANK(E12),ISBLANK(F12)),0,IF(B12="home",F12-E12-B7,F12-E12))

Works perfect... you are a genius. Thank you so much for your quick response!!!!

or future reference, please give your threads a title that actually describes what your problem is, using words/terms that could be used in a search function

Also, to mark a thread solved, use the thread tools above your 1st post, and select "mark as solved" (I will do it for you this time)

Thanks

Thanks FDibbins.... will do.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1