I am working through my company's annual salary review process. I would like to be able to make changes to any of the columns and it affect the others. Basically, I want to be able to change the % and it adjust the increase amount and new salary. Or if I change the increase amount that it change the percentage and total, and if I change the new salary, it factors the increase and percentage.
EDIT: I should also add that there is a column for current salary.
fh.JPG
Last edited by rebeccasievert; 08-05-2019 at 09:34 PM.
What you ask is not functionally available in Excel. A cell can only contain a value (that which you enter) or a formula (a calculation based upon input to another cell). You cannot have it both ways. It is an either/or situation.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Agree with Allan.
A work-around to this would be to have those "variable" cells on their own, then, depending on what is entered and what is left blank, a 2nd set of cells would then run the required calcs for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks