Don't think it's possible, but I thought I would ask.

  • Thread starter Thread starter smaumau
  • Start date Start date
S

smaumau

I need to create a spreadsheet that starts with an employee's curren
salary hard-coded. There are a two more important columns: the firs
is "% increase" and the second is "Future Salary." Is there a way tha
you can enter a value into either one and the other is populated. I
other words, some managers may want to use the % increase to get th
future salary and others may want to enter the future salary to get th
% increase. Any help would be greatly appreciated
 
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.

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Totals 1
Calculating Wage Increases on a Sliding Scale 1
Please Help w/ Functions 2
Sum by Cost Center 2
Multiple Conditions Setup with an Array?? Not Working?? 2
Formula, Pivot Table, ??? Beats me 2
How do I sum here using criteria there? 10
What function(s) to use? 1

Back
Top