You could do this with a Worksheet_Change macro. Whichever cell changes,
you'd calculate the other one.
What would be easier and perhaps more intuitive is to have two input columns
and two calculated columns. So, if you input a value in the percentage
column it would display the new salary in the future salary column; if you
input a value in the future salary column, it would display the percenatge
increase. Just a thought.
"smaumau" < XXXX@XXXXX.COM > wrote in