software

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


Do you want the number to be the same in the next 3 columns as the one
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 gt; a2 =a1, a3 =a1, a4 =a1

Not sure if this is what you are looking for?--
comotoman
------------------------------------------------------------------------
comotoman's Profile: www.excelforum.com/member.php...oamp;userid=27292
View this thread: www.excelforum.com/showthread...hreadid=503372Assuming 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.

quot;Cindyquot; wrote:

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

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 Backmannquot;Cindyquot; wrote:

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

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

quot;comotomanquot; wrote:

gt;
gt; Do you want the number to be the same in the next 3 columns as the one
gt; you changed?
gt;
gt; Ex. a1 =2 a2=3 a3=5 a4=7
gt;
gt; change a2:a4 to the same as column a1 '2'
gt;
gt; if thats the case then your formula would be gt; a2 =a1, a3 =a1, a4 =a1
gt;
gt; Not sure if this is what you are looking for?
gt;
gt;
gt; --
gt; comotoman
gt; ------------------------------------------------------------------------
gt; comotoman's Profile: www.excelforum.com/member.php...oamp;userid=27292
gt; View this thread: www.excelforum.com/showthread...hreadid=503372
gt;
gt;