Hi all
I need to apply price changes to diesel in a fleet based on the date that the change occurred.
So in my mind I need a formula in column C that multiplies that value in column B with the correct price value in column F based on the date.
I hope you can help.
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to apply price changes to diesel in a fleet based on the date that the change occurred.
So in my mind I need a formula in column C that multiplies that value in column B with the correct price value in column F based on the date.
I hope you can help.
A | B | C | D | E | F | |
1 | Fill up Date | Diesel Litres | Price | Price Change Date | New Price | |
2 | 2018/08/01 | 233,00 | 2018/08/01 | 13,31 | ||
3 | 2018/08/15 | 265,69 | 2018/09/12 | 14,49 | ||
4 | 2018/08/20 | 225,00 | 2018/10/18 | 14,99 | ||
5 | 2018/08/27 | 270,00 | ||||
6 | 2018/08/30 | 167,00 | ||||
7 | 2018/09/05 | 235,80 | ||||
8 | 2018/09/12 | 154,82 | ||||
9 | 2018/09/19 | 270,00 | ||||
10 | 2018/09/27 | 280,10 | ||||
11 | 2018/10/04 | 218,10 | ||||
12 | 2018/10/11 | 237,80 | ||||
13 | 2018/10/18 | 230,10 | ||||
14 | 2018/10/24 | 320,0 | ||||
15 | 2018/10/31 | 208,5 | ||||
16 | 2018/11/07 | 272,1 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>