Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default calculating wage increases for multiple employees.

How do you calculate a wage increase involving various percetage increases
and various pay scales with multiple emplyees.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default calculating wage increases for multiple employees.

Build up a table which lists each employee and the percentage increase
they should get, and then make use of VLOOKUP to obtain the
appropriate increase for each employee.

Hope this helps.

Pete

On Nov 18, 6:46 pm, Down South <Down
wrote:
How do you calculate a wage increase involving various percetage increases
and various pay scales with multiple emplyees.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
variable annual wage increases based on start date spence Excel Worksheet Functions 7 April 24th 07 03:38 AM
how do i set up wage slips for my casual employees missfit New Users to Excel 2 January 18th 07 12:34 AM
divide records equally among multiple employees Martin Leffler Excel Worksheet Functions 5 August 28th 06 11:24 PM
Use Excel to track multiple employees daily work schedules HollyTLove Excel Discussion (Misc queries) 0 September 18th 05 09:42 AM
Formula calculating fulltime/parttime vs employees. VP Excel Discussion (Misc queries) 1 September 8th 05 04:41 AM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"