software

I need to create a spreadsheet that starts with an employee's current
salary hard-coded. There are a two more important columns: the first
is quot;% increasequot; and the second is quot;Future Salary.quot; Is there a way that
you can enter a value into either one and the other is populated. In
other words, some managers may want to use the % increase to get the
future salary and others may want to enter the future salary to get the
% increase. Any help would be greatly appreciated.--
smaumau
------------------------------------------------------------------------
smaumau's Profile: www.excelforum.com/member.php...oamp;userid=33128
View this thread: www.excelforum.com/showthread...hreadid=529408You 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.

Regards

Trevorquot;smaumauquot; gt; wrote in
message ...
gt;
gt; I need to create a spreadsheet that starts with an employee's current
gt; salary hard-coded. There are a two more important columns: the first
gt; is quot;% increasequot; and the second is quot;Future Salary.quot; Is there a way that
gt; you can enter a value into either one and the other is populated. In
gt; other words, some managers may want to use the % increase to get the
gt; future salary and others may want to enter the future salary to get the
gt; % increase. Any help would be greatly appreciated.
gt;
gt;
gt; --
gt; smaumau
gt; ------------------------------------------------------------------------
gt; smaumau's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33128
gt; View this thread: www.excelforum.com/showthread...hreadid=529408
gt;