Forum Discussion
Solved
Merit Increase Schedule Formula
I have a payroll file where I forecast out for the next five years how much base pay is with scenarios of merit earned by percentage. I have a working formula I created but wonder if there's an easie...
You may add helper data as in column G
and use formula
=[@[Salary Amount]]*(1+SUM( $F$1:INDEX($F$1:$F$7, MATCH( DATE([@Year],[@Month],1), $G$1:$G$7, 1 ) ) ))
You may add helper data as in column G
and use formula
=[@[Salary Amount]]*(1+SUM( $F$1:INDEX($F$1:$F$7, MATCH( DATE([@Year],[@Month],1), $G$1:$G$7, 1 ) ) ))
Thank you so much! This worked.
Jpalaci1 , you are welcome