Employee Move to Next Level

ChetanPuri

Board Regular
Joined
Sep 5, 2018
Messages
97
Office Version
  1. 365
Platform
  1. Windows
Hi Excel Community,

I am trying to Build a Formula in excel for employees who are on different levels each year they get promoted on the next level, until they reach the last level within their classification on Column E . Is there a way to automate that in column C , if they are other than salaried staff they get an increase to the next level and then when CPI Increases they get a new rate whereas salaried employees they get CPI, any help would be greatly appreciated.

Increase
Book11
ABCDEFGHIJKLM
1Current LevelDefault RoleStart DateAnniversary dateNew RateCPI Increase 01 July 2024New Level
2Pay RateCPI2%
3SALARYManager20,400.00GREENTREE Contract Listing Report
4SALARYDirectorClassificationCurrent FutureOld RateNew Rate
5SALARYDirectorL11SCHADS L1.1SCHADS L1.2$2$2.04
6SALARYManagerL12SCHADS L1.2SCHADS L1.33.00$3.06
7SALARYDirectorL13SCHADS L1.3SCHADS L1.34.00$4.08
8SALARYManagerL21SCHADS L2.1SCHADS L2.25$5.10
9SCHADS L5.3AdminL22SCHADS L2.2SCHADS L2.3
10SCHADS L6.3AdminL23SCHADS L2.3SCHADS L2.3
11 L24SCHADS L2.4SCHADS L3.1
12SALARYDirectorL31SCHADS L3.1SCHADS L3.2
13SALARYDirectorL32SCHADS L3.2SCHADS L3.3
14SCHADS L6.2IL CoordinatorSCHADS L6.37/03/20237/04/202453$54.06L33SCHADS L3.3SCHADS L3.4
15SCHADS L5.2CoordinatorL34SCHADS L3.4SCHADS L3.4
16SCHADS L6.2IL CoordinatorL41SCHADS L4.1SCHADS L4.2
17SCHADS L6.2IL CoordinatorL42SCHADS L4.2SCHADS L4.3
18SCHADS L6.2IL CoordinatorL43SCHADS L4.3SCHADS L4.4
19SCHADS L6.1IL CoordinatorL44SCHADS L4.4SCHADS L5.1
20SCHADS L6.2IL CoordinatorL51SCHADS L5.1SCHADS L5.2
21SCHADS L6.2IL CoordinatorL52SCHADS L5.2SCHADS L5.3
22SCHADS L6.2AdminL53SCHADS L5.3SCHADS L5.3+$20
23SCHADS L5.2AdminL53+20SCHADS L5.3+$20SCHADS L6.1
24SALARYManagerL61SCHADS L6.1SCHADS L6.2
25SALARYManagerL62SCHADS L6.2SCHADS L6.3
26SCHADS L5.3+$20AdminL63SCHADS L6.3SCHADS L7.153$54.06
27SCHADS L5.3AdminL71SCHADS L7.1SCHADS L7.2
28SCHADS L6.3AdminL72SCHADS L7.2SCHADS L7.3
29SCHADS L4.1AdminL73SCHADS L7.3SCHADS L8.1
30SALARYAdminL81SCHADS L8.1SCHADS L8.2
31SCHADS L4.1AdminL82SCHADS L8.2SCHADS L8.3
32SALARYAdminL83SCHADS L8.3
33SCHADS L4.1AdminSALARYCPI
34SCHADS L4.4AdminL22CASSCHADS L2.2 CASUALCPI
35SCHADS L4.1AdminL23CASSCHADS L2.3 CASUALCPI
36SCHADS L2.1AdminL41CASSCHADS L4.1 CASUALCPI
37SCHADS L5.1Admin
Sheet1
Cell Formulas
RangeFormula
H3H3=20000*(1+M2)
M5:M8,M26M5=L5*(1+$M$2)
C14C14=J26
F14:G14F14=L26
K5:K6,K8:K9,K11:K14,K16:K31K5=J6
K7,K10,K15K7=J7
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top