Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
I'm using Excel 2000 and have the following problem:
Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
Very well explained but what is the question?
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "jeffmp21" wrote in message ... I'm using Excel 2000 and have the following problem: Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
You've left out some vital information.
What is the base raise? How does performance rating affect the percentage given? How does the position of current salary within the range affect the percentage given? Shouldn't column A be "prepopulated" too? If not, how should it be calculated? In article , jeffmp21 wrote: I'm using Excel 2000 and have the following problem: Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
=IF(yousaywhatyouneed,maybewecanhelp,false)
-- regards from Brazil Thanks in advance for your feedback. Marcelo "jeffmp21" escreveu: I'm using Excel 2000 and have the following problem: Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
"JE McGimpsey" wrote: You've left out some vital information. What is the base raise? the rate is conditional based on employee rating (10,20,30,40,50) and where your current wage falls within in the range for the wage based on the jobcode. How does performance rating affect the percentage given? Rating and where your wage falls within the range for your jobcode determines the percentage given. How does the position of current salary within the range affect the percentage given? Shouldn't column A be "prepopulated" too? If not, how should it be calculated? You are correct A is also prepopulated. The matrix looks like this Rating Under Range/ min Lower Third/Middle Third/Upper Third/Over Range 50 5% 4.5% 4% 3.5% 3.0% 40 4.5% 4.0% 3.5% 3.0% 2.0% 30 4.0% 3.5% 3.0% 2.5% 1.0% 20 2.0% 1.5% 1.0% 0% 0% 10 0% 0% 0% 0% 0% in our example: A employee received a 30 rating and made $51,974. the min for his class was $30,746, Mid = $43,045, Max = $55,097 He is therefore in the upper third and has a 30 rating so the raise is 2.5% I need to calculate the raise for several thousand employees. All other information is provided. In article , jeffmp21 wrote: I'm using Excel 2000 and have the following problem: Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if Statement?
The matrix looks like this
Rating Under Range/ min Lower Third/Middle Third/Upper Third/Over Range 50 5% 4.5% 4% 3.5% 3.0% 40 4.5% 4.0% 3.5% 3.0% 2.0% 30 4.0% 3.5% 3.0% 2.5% 1.0% 20 2.0% 1.5% 1.0% 0% 0% 10 0% 0% 0% 0% 0% in our example: A employee received a 30 rating and made $51,974. the min for his class was $30,746, Mid = $43,045, Max = $55,097 He is therefore in the upper third and has a 30 rating so the raise is 2.5% I need to calculate the raise for several thousand employees. All other information is provided. Sandy I hope that helps! thank you for helping! "Sandy Mann" wrote: Very well explained but what is the question? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "jeffmp21" wrote in message ... I'm using Excel 2000 and have the following problem: Column A has an employee's performance rating 10,20,30,40, or 50 Column B has the employee's current salary Column C will calculate the employees increase 0, .5, 1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0 Column D has a min wage range Column E has a middle wage range Column F has the max wage Columns B, D,E, and F are prepopulated. Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid= 43,043, Max = 55,097 Would receive a 2.5% raise Based on: Meeting expections (30 rating) but is in the upper third of the range |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple IF statement | Excel Worksheet Functions | |||
Multiple IF statement | Excel Discussion (Misc queries) | |||
Multiple IF Statement | Excel Worksheet Functions | |||
Multiple If Statement | Excel Worksheet Functions | |||
Help with a multiple OR statement. | Excel Discussion (Misc queries) |