• 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

  • SaaS Test Budgeted Labor.xlsx
    76.6 KB · Views: 3
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