+ Reply to Thread
Results 1 to 2 of 2

how to calculate fuel prices

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to calculate fuel prices

    I have an excel doc with a few fields already given for the prices of fuel on particular days. I need to generate a formula that will produce the fuel price for a particular transaction based on the type of fuel and the particular date.The prices change each week and there are three possible weeks in the table. the table provided gives the date on which the prices are changed, and the various prices for three kinds of fuel. i figure i need a nested if or vlookup function. any suggestions?

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: how to calculate fuel prices

    It would be easier to recommend a solution if you could upload a sample workbook. But yes, =VLOOKUP() or =SUMPRODUCT() sounds like a likely solution.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1