Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula's
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula's
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 a2 =a1, a3 =a1, a4 =a1 Not sure if this is what you are looking for? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=503372 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula's
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. "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula's
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula's
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 "comotoman" wrote: 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 a2 =a1, a3 =a1, a4 =a1 Not sure if this is what you are looking for? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=503372 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |