Scribd
Upload
40 views20 pages

Nested If Assignment

The document outlines several pay structures for employees with different salary brackets and incentive structures. It provides salary brackets with corresponding bonus or incentive percentages. The structures are adjusted incrementally with additional brackets added and incentive percentages modified in subsequent versions. The document aims to define a standardized pay scale with incentives tied to basic pay and other compensation factors.

Uploaded by

SAMRAT CHOWDHURY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
40 views20 pages

Nested If Assignment

The document outlines several pay structures for employees with different salary brackets and incentive structures. It provides salary brackets with corresponding bonus or incentive percentages. The structures are adjusted incrementally with additional brackets added and incentive percentages modified in subsequent versions. The document aims to define a standardized pay scale with incentives tied to basic pay and other compensation factors.

Uploaded by

SAMRAT CHOWDHURY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 20

EMPLOYEE NAME BASIC SALARY BONUS

A 5000 1000
B 120000 2000
C 50000 2000
D 80000 2000
E 100000 2000
F 20000 1000

BASIC SALARY BONUS


Upto 20000 1000
>20000 2000
EMPLOYEE NAME BASIC SALARY BONUS
A 5000
B 120000
C 50000
D 80000
E 100000
F 20000

BASIC SALARY BONUS


UPTO 20000 1000
20001-50000 2000
>50000 3000
EMPLOYEE NAME BASIC SALARY BONUS
A 5000
B 120000
C 50000
D 80000
E 100000
F 20000

BASIC SALARY BONUS


UPTO 20000 1000
20001-50000 2000
50001-80000 2500
>80000 3000
EMPLOYEE NAME BASIC SALARY BONUS
A 5000
B 120000
C 50000
D 80000
E 100000
F 20000

BASIC SALARY BONUS


UPTO 20000 1000
20001-50000 2000
50001-80000 2500
8000-100000 3500
>100000 4000
EMPLOYEE NAME BASIC SALARY BONUS
P 7000 700
Q 15000 3000
R 40000 8000
S 90000 18000
T 220000 44000
U 70000 14000
TOTAL 442000

BASIC SALARY BONUS


UPTO 10000 10% OF BASIC SALARY
10000 or more 20 % OF BASIC SALARY
EMPLOYEE NAME BASIC SALARY BONUS
P 7000
Q 15000
R 40000
S 90000
T 220000
U 70000
TOTAL 442000

BASIC SALARY BONUS


UPTO 10000 10% OF BASIC SALARY
10001-20000 20 % OF BASIC SALARY
>20000 30 % OF BASIC SALARY
EMPLOYEE NAME BASIC SALARY BONUS
P 7000
Q 15000
R 40000
S 90000
T 220000
U 70000
TOTAL 442000

BASIC SALARY BONUS


UPTO 10000 10% OF BASIC SALARY
10001-20000 20 % OF BASIC SALARY
20001-80000 30 % OF BASIC SALARY
>80000 40% OF BASIC SALARY
EMPLOYEE NAME BASIC SALARY BONUS
P 7000
Q 15000
R 40000
S 90000
T 220000
U 70000
TOTAL 442000

BASIC SALARY BONUS


UPTO 10000 10% OF BASIC SALARY
10001-20000 20 % OF BASIC SALARY
20001-80000 30 % OF BASIC SALARY
80001-100000 40% OF BASIC SALARY
>100000 50% OF BASIC SALARY
EMPLOYEE NA CITY BASIC SALARY CITY ALLOWANCE
E DELHI 15000 5000
F MUMBAI 25000 8000
G DELHI 9000 5000
H MUMBAI 125000 8000
I MUMBAI 9000 8000
J DELHI 30000 5000
TOTAL 213000

CITY CITY ALLOWANCE


DELHI 5000
MUMBAI 8000
EMPLOYEE NAME CITY BASIC SALARY CITY ALLOWANCE
E DELHI 15000
F MUMBAI 25000
G DELHI 9000
H MUMBAI 125000
I MUMBAI 9000
J CHENNAI 30000
TOTAL 213000

CITY CITY ALLOWANCE


DELHI 5000
MUMBAI 8000
CHENNAI 9000
EMPLOYEE NAME CITY BASIC SALARY CITY ALLOWANCE
E DELHI 15000
F MUMBAI 25000
G DELHI 9000
H MUMBAI 125000
I KOLKATTA 9000
J CHENNAI 30000
TOTAL 213000

CITY CITY ALLOWANCE


DELHI 5000
MUMBAI 8000
CHENNAI 9000
KOLKATTA 10000
EMPLOYEE NAME CITY BASIC SALARY CITY ALLOWANCE
E DELHI 15000
F MUMBAI 25000
G DELHI 9000
H GOA 125000
I KOLKATTA 9000
J CHENNAI 30000
TOTAL 213000

CITY CITY ALLOWANCE


DELHI 5000
MUMBAI 8000
CHENNAI 9000
KOLKATTA 10000
GOA 11000
EMPLOYEE NAME BASIC SALARY GRADE
L 40000 Grade A
M 20000 Grade A
N 8000 Grade A
O 15000 Grade A
P 9000 Grade A
Q 30000 Grade A

BASIC SALARY GRADE


upto 10000 GRADE A
>10000 GRADE B
EMPLOYEE NAME BASIC SALARY CATEGORY
L 40000
M 20000
N 8000
O 15000
P 9000
Q 30000

BASIC SALARY GRADE


upto 10000 GRADE A
10001-15000 GRADE B
>15000 GRADE C
EMPLOYEE NAME BASIC SALARY CATEGORY
L 40000
M 20000
N 8000
O 15000
P 9000
Q 30000

BASIC SALARY GRADE


upto 10000 GRADE A
10001-15000 GRADE B
15001-20000 GRADE C
>20000 GRADE D
EMPLOYEE NAME BASIC SALARY CATEGORY
L 40000
M 20000
N 8000
O 15000
P 9000
Q 30000

BASIC SALARY GRADE


upto 10000 GRADE A
10001-15000 GRADE B
15001-20000 GRADE C
20001-35000 GRADE D
>35000 GRADE E
EMPLOYEEBASIC PAY VARIABLE PAY INCENTIVE
K 6000 3000 4500
L 100000 50000 50000
M 90000 45000 45000
N 50000 25000 25000
O 12000 6000 6000
P 8000 4000 4000

BASIC + VARIABLE INCENTIVE


UPTO 10000 1/2*(BASIC+VARIABLE)
>10000 1/3*(BASIC + VARIABLE)
EMPLOYEE BASIC PAY VARIABLE PAY INCENTIVE
K 6000 3000
L 100000 50000
M 90000 45000
N 50000 25000
O 12000 6000
P 8000 4000

BASIC + VARIABLE INCENTIVE


UPTO 10000 1/2*(BASIC+VARIABLE)
10001-20000 1/3*(BASIC + VARIABLE)
>20000 1/4*(BASIC + VARIABLE)
EMPLOYEE BASIC PAY VARIABLE PAY INCENTIVE
K 6000 3000
L 100000 50000
M 90000 45000
N 50000 25000
O 12000 6000
P 8000 4000

BASIC + VARIABLE INCENTIVE


UPTO 10000 1/2*(BASIC+VARIABLE)
10001-20000 1/3*(BASIC + VARIABLE)
20001-100000 1/4*(BASIC + VARIABLE)
>100000 1/5*(BASIC + VARIABLE)
EMPLOYEE BASIC PAY VARIABLE PAY INCENTIVE
K 6000 3000
L 100000 50000
M 90000 45000
N 50000 25000
O 12000 6000
P 8000 4000

BASIC + VARIABLE INCENTIVE


UPTO 10000 1/2*(BASIC+VARIABLE)
10001-20000 1/3*(BASIC + VARIABLE)
20001-100000 1/4*(BASIC + VARIABLE)
100001-140000 1/5*(BASIC + VARIABLE)
>140000 1/6*(BASIC + VARIABLE)

You might also like