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.
--
Kevin Backmann


"Cindy" wrote:

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