+ Reply to Thread
Results 1 to 9 of 9

Formula of How many Miles i Drive (Formula of Mileage)

  1. 12-15-2018, 11:23 AM #1
    DarkCoder
    DarkCoder is offline
    Registered User
    Join Date
    12-15-2018
    Location
    USA, California
    MS-Off Ver
    2016
    Posts
    7

    Formula of How many Miles i Drive (Formula of Mileage)

    Hello
    Anyone Knows Formula of Mileage and Formula of "How many Miles i drive" .
    Thanks

    This exact thing i want, "Mileage – formula needed for miles I drive x .53 cents" .
    Reply With QuoteRegister To Reply
  2. 12-15-2018, 11:31 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Hi

    Assuming I've understood the request, with the mileage in A1 then

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 12-15-2018, 11:42 AM #3
    DarkCoder
    DarkCoder is offline
    Registered User
    Join Date
    12-15-2018
    Location
    USA, California
    MS-Off Ver
    2016
    Posts
    7

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Thanks.
    I'm also thinking same.
    i just got confused because Mileage Formula is different.
    Last edited by AliGW; 12-15-2018 at 11:48 AM. Reason: Unnecessary quotation removed.
    Reply With QuoteRegister To Reply
  4. 12-15-2018, 11:48 AM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Can you clarify what you mean by 'mileage' formula. Is this some other formula you have on the sheet? Perhaps you're getting at a cell which contains the difference between two cells which contain a Start and End mileage reading.

    In which case assuming the start mileage is in A1 and the end mileage in B1 then

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-15-2018, 11:53 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Just as an aside, in your other thread you were asked to change the title, NOT open a new thread. Please do as you are asked in future to avoid confusion. I have closed your earlier thread.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 12-15-2018, 01:09 PM #6
    DarkCoder
    DarkCoder is offline
    Registered User
    Join Date
    12-15-2018
    Location
    USA, California
    MS-Off Ver
    2016
    Posts
    7

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Quote Originally Posted by AliGW View Post
    Just as an aside, in your other thread you were asked to change the title, NOT open a new thread. Please do as you are asked in future to avoid confusion. I have closed your earlier thread.
    This thread is different. and i already commented on my previous thread to delete it because that one solved.
    Reply With QuoteRegister To Reply
  7. 12-15-2018, 01:10 PM #7
    DarkCoder
    DarkCoder is offline
    Registered User
    Join Date
    12-15-2018
    Location
    USA, California
    MS-Off Ver
    2016
    Posts
    7

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Quote Originally Posted by Richard Buttrey View Post
    Can you clarify what you mean by 'mileage' formula. Is this some other formula you have on the sheet? Perhaps you're getting at a cell which contains the difference between two cells which contain a Start and End mileage reading.

    In which case assuming the start mileage is in A1 and the end mileage in B1 then

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Hmm Right Ok Thanks.
    Reply With QuoteRegister To Reply
  8. 12-15-2018, 01:16 PM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Quote Originally Posted by DarkCoder View Post
    This thread is different. and i already commented on my previous thread to delete it because that one solved.
    We do not delete threads.
    Reply With QuoteRegister To Reply
  9. 12-15-2018, 01:19 PM #9
    DarkCoder
    DarkCoder is offline
    Registered User
    Join Date
    12-15-2018
    Location
    USA, California
    MS-Off Ver
    2016
    Posts
    7

    Re: Formula of How many Miles i Drive (Formula of Mileage)

    Quote Originally Posted by AliGW View Post
    We do not delete threads.
    Oh Ok. Didn't know . Will keep in mind next time.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating Mileage rates based on different rates depending on cumulative miles travelled
    By mcadde83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2020, 12:22 PM
  2. [SOLVED] Help with a mileage formula
    By lagatorbug in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2018, 01:21 PM
  3. Mileage Form...Need help with auto populating total miles
    By corinnag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2017, 11:47 PM
  4. [SOLVED] Need a formula that will calculate miles between multiple destinations
    By gus.tavera in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2017, 07:00 PM
  5. calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rate
    By infinite2006 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2013, 04:32 PM
  6. calculate TOTAL mileage (first 2 miles set rate) all miles thereafter set rate
    By infinite2006 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-30-2013, 08:26 AM
  7. [SOLVED] How to use miles per hour and mileage to estimate travel time
    By OhioSnowBird13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2006, 10:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1