SALARY SHEET

 

SALARY SHEET

g~j †eZ‡bi 30% Nifvov, 20% wPwKrmvfvZv, 10% cÖwf‡W›U dvÛ , hv‡`i g~j †eZb 15,000 UvKvi wb‡P ev mgvb Zv‡`i BbKvg U¨v· 0, Avi hv‡`i g~j †eZb  40,000 UvKvi wb‡P ev mgvb Zv‡`i BbKvg U¨v· 5%,Avi hv‡`i g~j †eZb  50,000 UvKvi wb‡P ev mgvb Zv‡`i BbKvg U¨v· 10% n‡e|

A	B	C	D	E	F	G	H	I	J
1	ID NO	NAME	POSITION	BASIC	H.RENT	M.A	P.FUND	I-TAX	Total
2	201	Tareq	MD	40000
3	202	Tipu	Director	35000
4	203	Hasan	manager	30000
5	204	Luna	Driver	15000

 

wb‡b¥ m~G UvBc Ki‡Z n‡e :

1.    H.Rent m~G F2 N‡i   =SUM(E2*30%) Press Enter =E2*30% Press Enter.

2.    M.allownce m~G G2 N‡i =SUM(E2*20%) Press Enter =E2*20% Press Enter.

3.    P.Fund m~G H2 N‡i =SUM(E2*10%) Press Enter =E2*10% Press Enter.

4.    I-Tax m~G 12 N‡i

=IF(E2<=15000,E2*0%,IF(E2<=40000,E2*5%,IF(E2<=50000,E2*10%)))

5.    Total =E2+F2+G2-H2-I2   Enter