Forum Discussion

MS789-0's avatar
MS789-0
Copper Contributor
Apr 28, 2020

Excel formula query

Hi 

I generally only use Excel for basic stuff, but need to calculate some price differentials for a client.

I have some data of fuel prices on specific dates and need to fill in a column with the same price where our client paid a higher prices when buying fuel many times each day.

 

For instance, on 01 May 2019 the bulk fuel price was say £1.25 per litre and our client made several trips on the day. I need to fill in all of the cells for the day in question wit the bulk price.

 

I've attached a file that should explain it easier

 

Thanks in advance for your help

 

Marc

1 Reply

  • I have seen your data. Kindly let me know which specific columns do you want to find the price difference?

    Is it Fuel Cost I column B and Price Paid or Litres?

Resources