Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If statements...
I have an list of employees with various dates of joining, payrises are applicable too the month of joining. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Name 10/25/04 50,000 2.75% x x x Looking at an if statement that looks at the month then multiplies salary by increase and divide by 12 for the impact. Can anyone help. Kind Regards, Neil |
#2
|
|||
|
|||
If statements...
I'm guessing you have a table that will reference each month's pay increase. You can use the =month(A1) where A1 is a date. That will give you numbers 1 through 12 based on the date. You can build this into the if statements that reference your rate table (or however you have it designed). Hope it helps. Phillycheese -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=477913 |
#3
|
|||
|
|||
If statements...
Yes looked at that one, so if x = month then salary x percentage increase /
12, that worked on but the increase continues the same for say oct / nov / dec. So I would need to repeat formula after oct, again suggestions. Neil "Phillycheese5" wrote: I'm guessing you have a table that will reference each month's pay increase. You can use the =month(A1) where A1 is a date. That will give you numbers 1 through 12 based on the date. You can build this into the if statements that reference your rate table (or however you have it designed). Hope it helps. Phillycheese -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=477913 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
Logical ELSE statements | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |