I am creating a salary distribution spreadsheet where I need to be able to enter either a percentage into cell 1 or a dollar amount in cell 2 and have both cell values always equal each other.
The cell value, whether percentage or dollar amount, is a fraction of a total salary.
As an example, if a salary equals $100, I want to be able to determine either what the dollar amount of 25% of the salary is or what the percentage of $25 of the salary is. This is because sometimes I will know only the percentage, but other times I will know only the dollar amount.
So I want both cell 1 and cell 2 to equal each other, both be input cells, and be expressed in different ways.
(In this example where salary equals $100, I'd need cell 1 to equal 25% and cell 2 to equal $25, no matter which of the two cells I used to enter either 25%/$25.)
So far I have found that this code will get the cells to equal each other, but it does not allow for the cells values to be expressed in the different ways mentioned above.
Any advice would be greatly appreciated.
Bookmarks