• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Best way to calculate

P

PaulaBidiman

New Member
Hi everyone. Can you suggest a way for me to add in raises to this spreadsheet? Right now, my calculations are based on start date and annual salary. Now, I have several employees who got a raise in January and others who will get a raise in the near future. I need to keep the previous months calculated as they are and show the new amount for future months. I just am not sure how to tell excel that if those columns are filled in, use those and keep the previous amounts.
 

Attachments

How would you guys combine these two formulas? They work great as a stand alone but I am not getting them to combine properly.

=IF($C2>G$1,$F2/12,$F2/12+$B2) this is for the new raise

=IF(ISBLANK($C29),"",$F29/12*(IF($D29>J$4,0,1))*(IF($E29="",1,IF($E29<J$4,0,1)))) This one is for the current amount of budgeted labor
 
You must log in or register to reply here.
Back
Top