Formula Help on Personnel Comp Model

[hardk0re]

Hey,


Trying to build in a personnel model that assumes salary raises every june of every year. The model is built month by month.


I have an if statement comparing the current month with the start month to determine if the salary should be entered that month. When I try to factor in the raises however, my raise isn't being calculated into the later cells. It doesn't build on the salary-- it only increases the compensation by the raise percentage that month.


so if:


employee 1 started in January 2013 and the current month is Feb 2013, the $100,000 salary is divided by 12. If after 3 months, employee 1 is given a raise in June 2013 of 8%, my formula is 'if(feb 2013 > $jan 2013, (100000/12)*row of raise percentages).


so for feb 2013 to may 2013, the cell is 100000, but in june, it should show 108,000. If I continue dragging the formula, july will show 100,000 again. Help?


How can I build in the raise if I drag that formula across to the next cell?

 

[NARAYANK991]

Hi ,


Can you clarify where these two items of data will be stored ?


1. The amount of the raise , 8 % in your example


2. The start month from which the raise will come into effect


Narayan

 

[hardk0re]

The raise will come in june at 8%.


The salary is 100,000 so I'm expecting the salary to show as 108,000 in june.

 

[NARAYANK991]

Hi ,


When I asked where these items will be stored , I meant where in the worksheet ? Will there be a cell which will store this value of 8 % , and will there be another cell which will store the text June ?


Narayan