how to calculate prices

[k b]

Hello all

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?

 

[T. Valko]

Hello all

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?

See if this helps:

http://contextures.com/xlFunctions02.html