We have an online salary planning tool that isn't currently used by our entire organization. They have asked me to come up with a spreadsheet that has the same functionality as the tool which allows users to enter either a % or a $ amount for a salary increase and automatically calculates the other based on the input field. Where if Joe is making 10,000 and they type 5 in the % field the Amount filed populates with $500 and vice versa if they type $500 in the amt field, 5% populates in the % field. I can't figure out how to do this in excel because if they enter into the % field it would erase my formula. Reading over this I'm not sure I've explained it well enough, but I've attached my starting spreadsheet. I have the field set so you can enter a % and it will calculate the other fields, but that's as far as I've been able to get. I thought about putting formulas in hidden cells, but I'm not sure if that really how to do that and have the resulting amount show in a different field, if that's even possible.
Any assistance is always appreciated!
Bookmarks