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)