Forum Discussion
MS789-0
Apr 28, 2020Copper Contributor
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?