2023-24 Pay Record (Vlookup)

Emp. ID [Link]. Names City Age Salary

2075 1 Barjraj Delhi 42 ₹ 91,904
Emp ID
1560 2 Ramdin Verma Mumbai 22 ₹ 63,250
1024 3 Sharat Chandran Gujrat 31 ₹ 122,427
2140
2004 4 Birender Mandal Kanpur 38 ₹ 131,628
2033 5 Amit Delhi 33 ₹ 63,432 Salary
2447 6 Kushal Haryana 34 ₹ 103,884
1090 7 Kasid Kolkata 24 ₹ 138,795
2186 8 Shiv Prakash Pune 29 ₹ 67,331 Age
2368 9 Vikram Singh Jaipur 38 ₹ 53,966
1732 10 Sanjay Hyderabad 33 ₹ 119,255
1502 11 Abhi Lucknow 26 ₹ 31,037 Name
2333 12 Ram Dutt Gupta Kanpur 29 ₹ 125,500
2212 13 Khadak Singh Nagpur 26 ₹ 130,531
1891 14 Gurmit Singh Patna 40 ₹ 16,073 City
1852 15 Chanderpal Indore 44 ₹ 126,213
2140 16 Aman Thane 29 ₹ 109,135
2252 17 Khursid Bhopal 42 ₹ 72,577
1677 18 Rajeev Visakhapatnam 35 ₹ 111,863
1459 19 Durgesh Gujrat 31 ₹ 25,479
1810 20 Nahar Singh Jaipur 27 ₹ 130,194
1413 21 Ram Kumar Delhi 21 ₹ 110,766 1090 [Link].
1676 22 Sunder Paal Mumbai 44 ₹ 104,413 7
1424 23 Maansingh Aswal Lucknow 24 ₹ 93,650
1212 24 Rohit Patna 39 ₹ 93,692
1711 25 Lalit Bhopal 27 ₹ 93,735
1938 26 Sparsh Kolkata 38 ₹ 93,777
1602 27 Santosh Thane 39 ₹ 93,819
1924 28 Santosh Indore 42 ₹ 129,126
2140 29 Punit Khandelwal Jaipur 25 ₹ 36,283
1089 30 Kasid Delhi 36 ₹ 17,524
1207 31 Sunder Paal Indore 33 ₹ 110,572
2492 32 Rajeev Pune 42 ₹ 32,223
1404 33 Ram Kumar Hyderabad 33 ₹ 21,740
1349 34 Durgesh Surat 35 ₹ 87,243
1343 35 Amit Haryana 25 ₹ 24,814
2501 36 Sumit Kolkata 36 ₹ 49,963
2004 37 Mahesh Kanpur 27 ₹ 40,982
1791 38 Mahesh Saini Thane 31 ₹ 126,449
1897 39 Rahul Nagpur 41 ₹ 66,624
1462 40 Anup Das Visakhapatnam 21 ₹ 40,224
1885 41 Barjraj Delhi 23 ₹ 36,493
2028 42 Sunjay Mumbai 26 ₹ 107,643
1135 43 Vijay Gujrat 27 ₹ 130,452
1200 44 Vikram Singh Visakhapatnam 23 ₹ 46,220
1565 45 Mohit Lucknow 35 ₹ 30,360
2354 46 Sohit Lucknow 21 ₹ 74,141
2399 47 Rohit Kolkata 21 ₹ 94,620
1971 48 Harish Surat 22 ₹ 130,104
1886 49 Suresh Surat 33 ₹ 73,926
2013 50 Lalit Hyderabad 21 ₹ 109,485
₹ 109,135

29

Aman

Thane

Names City Age Salary

Kasid Kolkata 24 138,795
 2023-24 Pay Record (Hlookup)
Emp. ID 2075 1560 1024 2004 2033 2447 1090 2186 2368 1732 1502 2333 2212 1891 1852 2140 2252 1677 1459 1810 1413 1676 1424 1212 1711 1938 1602 1924 2140 1089 1207 2492 1404 1349 1343 2501 2004 1791 1897 1462 1885 2028 1135 1200 1565 2354 2399 1971 1886 2013

[Link]. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Names Barjraj Ramdin Verma Sharat Chandran Birender Mandal Amit Kushal Kasid Shiv Prakash Vikram Singh Sanjay Abhi Ram Dutt Gupta Khadak Singh Gurmit Singh Chanderpal Aman Khursid Rajeev Durgesh Nahar Singh Ram Kumar Sunder Paal Maansingh Aswal Rohit Lalit Sparsh Santosh Santosh Punit Khandelwal Kasid Sunder Paal Rajeev Ram Kumar Durgesh Amit Sumit Mahesh Mahesh Saini Rahul Anup Das Barjraj Sunjay Vijay Vikram Singh Mohit Sohit Rohit Harish Suresh Lalit

City Delhi Mumbai Gujrat Kanpur Delhi Haryana Kolkata Pune Jaipur Hyderabad Lucknow Kanpur Nagpur Patna Indore Thane Bhopal Visakhapatnam Gujrat Jaipur Delhi Mumbai Lucknow Patna Bhopal Kolkata Thane Indore Jaipur Delhi Indore Pune Hyderabad Surat Haryana Kolkata Kanpur Thane Nagpur Visakhapatnam Delhi Mumbai Gujrat Visakhapatnam Lucknow Lucknow Kolkata Surat Surat Hyderabad

Age 42 22 31 38 33 34 24 29 38 33 26 29 26 40 44 29 42 35 31 27 21 44 24 39 27 38 39 42 25 36 33 42 33 35 25 36 27 31 41 21 23 26 27 23 35 21 21 22 33 21

Salary ₹ 91,904 ₹ 63,250 ₹ 122,427 ₹ 131,628 ₹ 63,432 ₹ 103,884 ₹ 138,795 ₹ 67,331 ₹ 53,966 ₹ 119,255 ₹ 31,037 ₹ 125,500 ₹ 130,531 ₹ 16,073 ₹ 126,213 ₹ 109,135 ₹ 72,577 ₹ 111,863 ₹ 25,479 ₹ 130,194 ₹ 110,766 ₹ 104,413 ₹ 93,650 ₹ 93,692 ₹ 93,735 ₹ 93,777 ₹ 93,819 ₹ 129,126 ₹ 36,283 ₹ 17,524 ₹ 110,572 ₹ 32,223 ₹ 21,740 ₹ 87,243 ₹ 24,814 ₹ 49,963 ₹ 40,982 ₹ 126,449 ₹ 66,624 ₹ 40,224 ₹ 36,493 ₹ 107,643 ₹ 130,452 ₹ 46,220 ₹ 30,360 ₹ 74,141 ₹ 94,620 ₹ 130,104 ₹ 73,926 ₹ 109,485

Emp ID
1200

Salary ₹ 46,220

Age 23

Name Vikram Singh

City Visakhapatnam
 2023-24 Pay Record (Xlookup)
Emp. ID [Link]. Names City Region Age
2075 1 Barjraj Delhi Northern 42
1560 2 Ramdin Verma Mumbai Western 22
1024 3 Sharat Chandran Gujrat Western 31
2004 4 Birender Mandal Kanpur northern 38
2033 5 Amit Delhi Northern 33
2447 6 Kushal Haryana Nothern 34
1090 7 Kasid Kolkata Eastern 24
2186 8 Shiv Prakash Pune Western 29
2368 9 Vikram Singh Jaipur Northern 38
1732 10 Sanjay Hyderabad Southern 33
1502 11 Abhi Lucknow Northern 26
2333 12 Ram Dutt Gupta Kanpur Northern 29
2212 13 Khadak Singh Nagpur Western 26
1891 14 Gurmit Singh Patna Eastern 40
1852 15 Chanderpal Indore central 44
2140 16 Aman Thane Western 29
2252 17 Khursid Bhopal central 42
1677 18 Rajeev Visakhapatnam Southern 35
1459 19 Durgesh Gujrat Western 31
1810 20 Nahar Singh Jaipur Northern 27
1413 21 Ram Kumar Delhi Northern 21
1676 22 Sunder Paal Mumbai Western 44
1424 23 Maansingh Aswal Lucknow Northern 24
1212 24 Rohit Patna Eastern 39
1711 25 Lalit Bhopal central 27
1938 26 Sparsh Kolkata Eastern 38
1602 27 Santosh Thane Western 39
1924 28 Santosh Indore central 42
2140 29 Punit Khandelwal Jaipur Northern 25
1089 30 Kasid Delhi Northern 36
1207 31 Sunder Paal Indore central 33
2492 32 Rajeev Pune Western 42
1404 33 Ram Kumar Hyderabad Southern 33
1349 34 Durgesh surat Western 35
1343 35 Amit Haryana Northern 25
2501 36 Sumit Kolkata Eastern 36
2004 37 Mahesh Kanpur Northern 27
1791 38 Mahesh Saini Thane Western 31
1897 39 Rahul Nagpur Western 41
1462 40 Anup Das Visakhapatnam Southern 21
1885 41 Barjraj Delhi Northern 23
2028 42 Sunjay Mumbai Western 26
1135 43 Vijay Gujrat Western 27
1200 44 Vikram Singh Visakhapatnam Southern 23
1565 45 Mohit Lucknow Northern 35
2354 46 Sohit Lucknow Northern 21
2399 47 Rohit Kolkata Eastern 21
1971 48 Harish surat Western 22
1886 49 Suresh Delhi Northern 33
2013 50 Lalit Hyderabad Southern 21
Salary
₹ 91,904
₹ 63,250
₹ 122,427
Emp ID
₹ 131,628
₹ 63,432
2028
₹ 103,884
₹ 138,795
Names City Region Age
₹ 67,331
₹ 53,966 #NAME? #NAME? #NAME? #NAME?
₹ 119,255
₹ 31,037 Names City
₹ 125,500 Ram Dutt Gupta Kanpur
₹ 130,531
₹ 16,073 Salary
₹ 126,213 #NAME?
₹ 109,135
₹ 72,577
₹ 111,863
₹ 25,479
₹ 130,194
₹ 110,766
₹ 104,413
₹ 93,650
₹ 93,692
₹ 93,735
₹ 93,777
₹ 93,819
₹ 129,126
₹ 36,283
₹ 17,524
₹ 110,572
₹ 32,223
₹ 21,740
₹ 87,243
₹ 24,814
₹ 49,963
₹ 40,982
₹ 126,449
₹ 66,624
₹ 40,224
₹ 36,493
₹ 107,643
₹ 130,452
₹ 46,220
₹ 30,360
₹ 74,141
₹ 94,620
₹ 130,104
₹ 73,926
₹ 109,485
Salary
#NAME?
 2023-24 Pay Record
Emp. ID [Link]. Names City Region Age Monthly/Salary
2075 1 Barjraj Delhi Northern 42 ₹ 91,904
1560 2 Ramdin Verma Mumbai Western 22 ₹ 63,250
1024 3 Sharat Chandran Gujrat Western 31 ₹ 122,427
2004 4 Birender Mandal Kanpur northern 38 ₹ 131,628
2033 5 Amit Delhi Northern 33 ₹ 63,432
2447 6 Kushal Haryana Nothern 34 ₹ 103,884
1090 7 Kasid Kolkata Eastern 24 ₹ 138,795
2186 8 Shiv Prakash Pune Western 29 ₹ 67,331
2368 9 Vikram Singh Jaipur Northern 38 ₹ 53,966
1732 10 Sanjay Hyderabad Southern 33 ₹ 119,255
1502 11 Abhi Lucknow Northern 26 ₹ 31,037
2333 12 Ram Dutt Gupta Kanpur Northern 29 ₹ 125,500
2212 13 Khadak Singh Nagpur Western 26 ₹ 130,531
1891 14 Gurmit Singh Patna Eastern 40 ₹ 16,073
1852 15 Chanderpal Indore central 44 ₹ 126,213
2140 16 Aman Thane Western 29 ₹ 109,135
2252 17 Khursid Bhopal central 42 ₹ 72,577
1677 18 Rajeev Visakhapatnam Southern 35 ₹ 111,863
1459 19 Durgesh Gujrat Western 31 ₹ 25,479
1810 20 Nahar Singh Jaipur Northern 27 ₹ 130,194
1413 21 Ram Kumar Delhi Northern 21 ₹ 110,766
1676 22 Sunder Paal Mumbai Western 44 ₹ 104,413
1424 23 Maansingh Aswal Lucknow Northern 24 ₹ 93,650
1212 24 Rohit Patna Eastern 39 ₹ 93,692
1711 25 Lalit Bhopal central 27 ₹ 93,735
1938 26 Sparsh Kolkata Eastern 38 ₹ 93,777
1602 27 Santosh Thane Western 39 ₹ 93,819
1924 28 Santosh Indore central 42 ₹ 129,126
2140 29 Punit Khandelwal Jaipur Northern 25 ₹ 36,283
1089 30 Kasid Delhi Northern 36 ₹ 17,524
1207 31 Sunder Paal Indore central 33 ₹ 110,572
2492 32 Rajeev Pune Western 42 ₹ 32,223
1404 33 Ram Kumar Hyderabad Southern 33 ₹ 21,740
1349 34 Durgesh surat Western 35 ₹ 87,243
1343 35 Amit Haryana Northern 25 ₹ 24,814
2501 36 Sumit Kolkata Eastern 36 ₹ 49,963
2004 37 Mahesh Kanpur Northern 27 ₹ 40,982
1791 38 Mahesh Saini Thane Western 31 ₹ 126,449
1897 39 Rahul Nagpur Western 41 ₹ 66,624
1462 40 Anup Das Visakhapatnam Southern 21 ₹ 40,224
1885 41 Barjraj Delhi Northern 23 ₹ 36,493
2028 42 Sunjay Mumbai Western 26 ₹ 107,643
1135 43 Vijay Gujrat Western 27 ₹ 130,452
1200 44 Vikram Singh Visakhapatnam Southern 23 ₹ 46,220
1565 45 Mohit Lucknow Northern 35 ₹ 30,360
2354 46 Sohit Lucknow Northern 21 ₹ 74,141
2399 47 Rohit Kolkata Eastern 21 ₹ 94,620
1971 48 Harish surat Western 22 ₹ 130,104
1886 49 Suresh Delhi Northern 33 ₹ 73,926
2013 50 Lalit Hyderabad Southern 21 ₹ 109,485
 Countif IF
Annual Salary Salary Wise Emp. kanpur Western ₹ 91,904
₹ 1,102,848 Err:508 3 15 ₹ 63,250
₹ 759,000 Err:508 ₹ 119,255
₹ 1,469,124 Err:508 Sumif ₹ 31,037
₹ 1,579,536 Err:508 Rahul ₹ 125,500
₹ 761,184 Err:508 66,624 ₹ 130,531
₹ 1,246,608 Err:508
₹ 1,665,540 Err:508 Averageif Nested If
₹ 807,972 Err:508 delhi 65674.1667 0-30000
₹ 647,592 Err:508 kolkata 94288.6728 30001-50000
₹ 1,431,060 Err:508 Eastern 81153.3592 50001-75000
₹ 372,444 Err:508 75001-100000
₹ 1,506,000 Err:508 100001-150000
₹ 1,566,372 Err:508 Averageifs
₹ 192,876 Err:508 Kolkata Eastern
₹ 1,514,556 Err:508 94288.672783738
₹ 1,309,620 Err:508
₹ 870,924 Err:508
₹ 1,342,356 Err:508
₹ 305,748 Err:508
₹ 1,562,328 Err:508
₹ 1,329,192 Err:508
₹ 1,252,956 Err:508
₹ 1,123,804 Err:508
₹ 1,124,310 Err:508
₹ 1,124,815 Err:508
₹ 1,125,320 Err:508
₹ 1,125,826 Err:508
₹ 1,549,512 Err:508
₹ 435,396 Err:508
₹ 210,288 Err:508
₹ 1,326,864 Err:508
₹ 386,676 Err:508
₹ 260,880 Err:508
₹ 1,046,916 Err:508
₹ 297,768 Err:508
₹ 599,556 Err:508
₹ 491,784 Err:508
₹ 1,517,388 Err:508
₹ 799,488 Err:508
₹ 482,688 Err:508
₹ 437,916 Err:508
₹ 1,291,716 Err:508
₹ 1,565,424 Err:508
₹ 554,640 Err:508
₹ 364,320 Err:508
₹ 889,692 Err:508
₹ 1,135,440 Err:508
₹ 1,561,248 Err:508
₹ 887,112 Err:508
₹ 1,313,820 Err:508
 IF
Eligible
Eligible
Eligible
Not Eligible
Eligible
Eligible

Nested If
Poor Salary
Average Salary
Good Salary
Very Good Salary
Excellent Salary
 PV
EMI 4580
Percentage % 13%
Period 2
Amount ₹ 96,813.79

FV NPER
Premium 4000 Amount
Percentage % 14% Percentage %
Period 10 Period
Amount 500000
₹ 3,047,510.97 Final Amount ₹ 1,930,959.84

RATE
Amount 70000
Period 4
EMI -2440
Percentage % 2.33%
 PMT IPMT PPMT Charge
₹ 2,539.18 ₹ 634.58 ₹ 769.16 ₹ 137.00 PMT,IPMT,PPMT,PV,FV

NPER
70000
30.46%
4
 24 ₹ 1,372.98
28.06%
25000
₹ 32,951.45