Weeble
Board Regular
- Joined
- Nov 30, 2016
- Messages
- 95
- Office Version
- 365
I have a table with different dates in column A
<tbody>
</tbody>
I also have a list with different prices depending on the time of date.
<tbody>
</tbody>
I want to make a formula in D column that goes similiar. " IF col A =< Date from my list ; C * value from list )
So if the apples have been sold 2017-01-15 or earlier than that the calculated price should be 25,5.
But if it's been sold between 2017-02-01 and less than 2018-01-01 the price should be 27,6.
How would I do this an easy way?
a | b | c | d |
2017-01-15 | Apples | 5 | |
2017-02-15 | Apples | 4 |
<tbody>
</tbody>
I also have a list with different prices depending on the time of date.
2017-01-01 | 25,5 $ |
2017-02-01 | 27,6 $ |
2018-01-01 | 32,4 $ |
<tbody>
</tbody>
I want to make a formula in D column that goes similiar. " IF col A =< Date from my list ; C * value from list )
So if the apples have been sold 2017-01-15 or earlier than that the calculated price should be 25,5.
But if it's been sold between 2017-02-01 and less than 2018-01-01 the price should be 27,6.
How would I do this an easy way?