Hi there,
i am looking for a formula to enter into cells (JAN-DEC) for each row that calculates a % increase and is tied to the effective month column.
Is the only solution to do multiple IF statements for each cell? Any help is appreciated. Thanks.
<tbody>
</tbody>
i am looking for a formula to enter into cells (JAN-DEC) for each row that calculates a % increase and is tied to the effective month column.
Is the only solution to do multiple IF statements for each cell? Any help is appreciated. Thanks.
Core | Increase | Eff. Month | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | FY TOTAL |
10000 | 3% | MAR | 10000 | 10000 | 10300 | 10300 | 10300 | 10300 | 10300 | 10300 | 10300 | 10300 | 10300 | 10300 | 123000 |
10000 | 5% | SEP | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10500 | 10500 | 10500 | 10500 | 122000 |
<tbody>
</tbody>