I just want to look up the dates in A column with in the array in F column.If the date in column A is less than from the first starting date in column F, there is no a desired result. But if the date in A3 is between the date in F2 and F3, multiply the amount in column B3 by G2. If the date in A4 is greater or equal to F3 and F4, multiply the amount in B4 by G3 etc. What would be the best Excel Function to calculate this type of large date in Excel.
<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Thank you for your help and time
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Date | Amount | Desired result | starting Date | increase Rate | ||
2 | 12/31/2018 | 1,000 | 0 | 06/30/2019 | 5% | ||
3 | 07/30/2019 | 1,200 | 60 | 12/31/2019 | 7.5% | ||
4 | 12/31/2019 | 1,260 | 94.50 | 06/01/2020 | 9% | ||
5 | 06/15/2020 | 1354.50 | 121.50 | 12/31/2020 | 12% | ||
6 | 12/31/2020 | 1476.40 | 177.16 | ||||
7 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Thank you for your help and time