formula's

C

Cindy

i have 4 columns, i want to change the number in the first column and have it
automatically change the number in the other 3 columns.
example
1st column is - years of service
2nd column is - school pay per years
3rd column is - state pay per years
4th column is - actual pay
 
C

comotoman

Do you want the number to be the same in the next 3 columns as the on
you changed?

Ex. a1 =2 a2=3 a3=5 a4=7

change a2:a4 to the same as column a1 '2'

if thats the case then your formula would be > a2 =a1, a3 =a1, a4 =a1

Not sure if this is what you are looking for
 
B

BekkiM

Assuming you have [School Pay/Year] and [State Pay/Year] in a table on
different worksheets:

A B
1 Year Pay per Year
2 1 35000
3 2 37500

Your formula should look something like this:

A B
1 Year School Pay
2 2 =VLOOKUP(School!$A$1:School!$B$3,A2,2,false)

The formula for State Pay would be the same, just reference the array where
the state pay scale is located.

I don't see how your Actual Pay can be a formula, since it seems like it's a
manually entered value for each teacher.
 
K

Kevin B

You could create a lookup table based upon the years of service where the
first column is the Years of service, the second column is school pay per
years, the third is state pay per years and the fourth column is actual pay.
 
C

Cindy

sorry its not clear, i just want to change the years of service and have it
automatically change the pay rate in the other 3 columns
 
Top