You would have to use VBA ... a worksheet event such as Worksheet_Change
take a look he
http://www.cpearson.com/excel/events.htm
Come back if you need more help.
" wrote:
I have a spreadsheet which will be used to calculate salary
information.
Important columns a
Job Title - Current Salary - Proposed increase (%) - Proposed increase
($) - Proposed new salary
What has been requested by the client is to be able to select ether a
% or $ change to salary and have each column reflect the change. eg:
% increase updates $ increase and salary and $ increase changes %
and salary.
It is possible by introducing a circular reference but this is a _bad_
thing from all accounts. What other options would I have?
tia
W