If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula for distribution of charges
Hi, Im planning to create a spreadsheet wherein the distribution charges (col.D,E,F,G) from their salary will be made upon entry of their employee no. A B C D E F G Emp.Name Salary Comp.# Alp Brav Char Delt 3725 16 This is the employee code Salary Alp Brav Char Delt Comp# 0-999 1,550 50% 50% 1000-2599 950 20% 40% 30% 10% 3000-4500 750 10% 10% 40% 40% Emp.Name Comp# Paul Smith 16 Greg Simon 3258 Joel Tucker 2566 Is it possible for: 1. when the Comp # in column C will be entered column A & B will appear their respective name & salary? 2. Upon entry of the Comp.#, column D,E,F,G will likewise be computed and charges will be distributed. Hope you could help me make this possible. Thank you in advance. barachiel |
#2
|
|||
|
|||
formula for distribution of charges
Hi
if the employee code is in column A you can use VLOOKUP. e.g. if you enter the code in C2 use =VLOOKUP(C2,'Employee_Sheet'!$A$1:$C$,2,0) to get the employee name HTH Frank barachiel wrote: Hi, Im planning to create a spreadsheet wherein the distribution charges (col.D,E,F,G) from their salary will be made upon entry of their employee no. A B C D E F G Emp.Name Salary Comp.# Alp Brav Char Delt 3725 16 This is the employee code Salary Alp Brav Char Delt Comp# 0-999 1,550 50% 50% 1000-2599 950 20% 40% 30% 10% 3000-4500 750 10% 10% 40% 40% Emp.Name Comp# Paul Smith 16 Greg Simon 3258 Joel Tucker 2566 Is it possible for: 1. when the Comp # in column C will be entered column A & B will appear their respective name & salary? 2. Upon entry of the Comp.#, column D,E,F,G will likewise be computed and charges will be distributed. Hope you could help me make this possible. Thank you in advance. barachiel |
#3
|
|||
|
|||
formula for distribution of charges
Mr.Frank,
Thanks for your advised on my question # 2, can you help me find a solution for my other question (#1)? barachiel -----Original Message----- Hi if the employee code is in column A you can use VLOOKUP. e.g. if you enter the code in C2 use =VLOOKUP(C2,'Employee_Sheet'!$A$1:$C$,2,0) to get the employee name HTH Frank barachiel wrote: Hi, Im planning to create a spreadsheet wherein the distribution charges (col.D,E,F,G) from their salary will be made upon entry of their employee no. A B C D E F G Emp.Name Salary Comp.# Alp Brav Char Delt 3725 16 This is the employee code Salary Alp Brav Char Delt Comp# 0-999 1,550 50% 50% 1000-2599 950 20% 40% 30% 10% 3000-4500 750 10% 10% 40% 40% Emp.Name Comp# Paul Smith 16 Greg Simon 3258 Joel Tucker 2566 Is it possible for: 1. when the Comp # in column C will be entered column A & B will appear their respective name & salary? 2. Upon entry of the Comp.#, column D,E,F,G will likewise be computed and charges will be distributed. Hope you could help me make this possible. Thank you in advance. barachiel . |
#4
|
|||
|
|||
formula for distribution of charges
Hi
you can use the VLOOKUP formula for all other columns as well (just adapt the third parameter). If you like, you can send me an example sheet (frank[dot]kabel[at]freenet[dot]de) and i'll set-up an example row for you Frank barachiel wrote: Mr.Frank, Thanks for your advised on my question # 2, can you help me find a solution for my other question (#1)? barachiel -----Original Message----- Hi if the employee code is in column A you can use VLOOKUP. e.g. if you enter the code in C2 use =VLOOKUP(C2,'Employee_Sheet'!$A$1:$C$,2,0) to get the employee name HTH Frank barachiel wrote: Hi, Im planning to create a spreadsheet wherein the distribution charges (col.D,E,F,G) from their salary will be made upon entry of their employee no. A B C D E F G Emp.Name Salary Comp.# Alp Brav Char Delt 3725 16 This is the employee code Salary Alp Brav Char Delt Comp# 0-999 1,550 50% 50% 1000-2599 950 20% 40% 30% 10% 3000-4500 750 10% 10% 40% 40% Emp.Name Comp# Paul Smith 16 Greg Simon 3258 Joel Tucker 2566 Is it possible for: 1. when the Comp # in column C will be entered column A & B will appear their respective name & salary? 2. Upon entry of the Comp.#, column D,E,F,G will likewise be computed and charges will be distributed. Hope you could help me make this possible. Thank you in advance. barachiel . |
Thread Tools | |
Display Modes | |
|
|