Skip to main content

Salary Slip (BASIC, HRA, DA, TA, NET SALARY) & Extra Formulas || Advance Excel

 

Emp roll no

Name

Basic

HRA

DA

TA

NET SALARY

1

a

5500

?

?

?

?

2

b

7900

?

?

?

?

3

c

8475

?

?

?

?

4

d

15700

?

?

?

?

5

e

21000

?

?

?

?

6

f

9584

?

?

?

?

7

g

22700

?

?

?

?

8

h

5245

?

?

?

?

9

i

42000

?

?

?

?

 

 

Notes

if basic salary is more then 7000 hra 18% of basic, da 15% of basic and ta 12% of basic

if basic salary is more then 5000 hra 15% of basic, da 13% of basic and ta 10% of basic

if basic salary is less then 5000 hra 12% of basic, da 11% of basic and ta 8% of basic


Basic : Basic Salary

HRA : House Rent Allowance

DA : Dearness Allowance

TA : Travelling Allowance






=FIND("R","ARPAN",1)
=ABS(-585)
=CEILING(75.78787878,1)
=ROUND(75.7777777,3)
=EVEN(12)
=ODD(26)
=EXACT("ARPAN","arpan")
=FACT(5)
=LEFT("COMPUTER",4)
=LEN("COMPUTER")
=LOWER(E40)
=UPPER(E43)
=MOD(51,5)
=POWER(4,4)
=PRODUCT(7,8,9,15)
=REPLACE("COMPUTER",1,2,"AB")
=REPT("ARPAN",10)
=SQRT(25)








Comments

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...

Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

  Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

Advance Excel Syllabus (M S OFFICE EXCEL 2021)

  Advance Excel Syllabus   Home Menu: ·          Clipboard ·          Font ·          Alignment ·          Numbers ·          Styles ·          Cells ·          Editing   Insert Menu: ·          Pivot Table & Pivot Chats ·          Tables ·          Charts ·          Sparklines ·          Filters ·          Link   Page Layout Menu: ·          Page Setup ·   ...