Please Help w/ Functions

  • Thread starter Thread starter rpainter
  • Start date Start date
R

rpainter

Hello. I don't know if I am posting in the right place or not, but
need some help. I know very little about Excel, but my boss has aske
me to do this. let me tell you what I have. 6 Columns: Name, Socia
Sec. #, Pay Grade, Current Salary, % Increase, and New Salary. I als
have another table with four columns: Grade, Minimum, Market, an
Maximum.

What I want to do is this: When We type in the Grade, Current Salary
and % Increase, I want the new salary field to be filled in with th
correct info. For example, If I type grade=4, Current Salary= 35,000
and % Increase=3. I want the formula to look at the Grade column, g
down to 4, over to market, and take 3% of the market. I then want tha
3% to be added to the current salary and that new number displayed i
the New Salary field.

Is this possible? And how would I do it? Thanks for all of you
help.

Rusty Painte
 
Assuming that the Grade Minimum, Market, and Maximum is in H1:K20, and the
other data is in A1:F10, the New Salary in F2, Increase in E2, would be

=D2+VLOOKUP(C2,$H$1:$K$20,3,FALSE)*E2


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I guess Market columns has all dollar values??

say
1.ur first table is in columns A-F in the order you wrote.
2.second from K-N and you got 10 grades
3.ur %increase column is in the % format.

enter this formula in F2.fill down.

=VLOOKUP(C2,$K$2:$N$11,3,0) * E2 +D2

c2 - the cell you are looking for

$K$2:$N$9 - the range you want to look into. If this range
is in different sheet or file dont type anything. place
your cursor in the formula and select the range using ur
mouse. it will be filled automatically then.

3 - the column in the range you want to be
returned. 'market' is the 3rd column in the range.
 
Back
Top