To
Create A Salary Sheet (‡Kvb
cÖwZôv‡bi ‡eZ‡bi wnmve †ei Kiv) t
NB t †Kvb cÖwZôv‡bi ‡eZ‡bi wnmve wbw`©ó kZ©mv‡c‡¶ Kiv nq| cÖ‡Z¨‡Ki g~j
†eZ‡bi Dci wfwË K‡i Zv‡K House
Rent, Medical Alaunce, Lunch,
BZ¨vw` †`Iqv nq Ges Profidient Fund, Income Tax, Group Insurence
BZ¨vw` Zvi †eZb †_‡K ivLv nq| g‡b
ivL‡eb mewKQyB Kiv nq Basic A_©vr g~j †eZ‡bi Dci wfwË K‡i| wb‡æ wbw`©ó
kZ©mv‡c‡¶ GKwU cÖwZôv‡bi †eZ‡bi
wnmveKvh© m¤úv`‡bi c×wZ †`Iqv n‡jv| Avcwb †Kvb cÖwZôv‡bi †eZ‡bi wnmve †ei
Ki‡Z n‡j H cÖwZôv‡bi kZ©¸‡jv Av‡M
Rvb‡Z n‡e Zvici wnmve ïi“ Ki‡Z n‡e| Zvn‡j Avmyb Avgiv wbæwjwLZ QKwU
ˆZix K‡i †eZ‡bi wnmve †ei Kiv wkwL|
Gevi D³ QKwU‡Z wbæwjwLZ m~θ‡jv
cÖ‡qvM Kwi| g‡b ivL‡eb wbw`©ó Cell Gi g‡a¨ m~θ‡jv cÖ‡qvM Kivi ci Inter
Press Ki‡Z n‡e| wbgoewjwLZ m~θ‡jv GKwU wbw`ªó k‡Z©i Dci wfwË K‡i †`Iqv
Av‡Q| m~θ‡jvi we¯—vwiZ kZ©vejx eyS‡Z
bv cvi‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|
Bnv cvi‡j †h †Kvb k‡Z©i Dci wfwË K‡i ‡eZ‡bi wnmve †ei Ki‡Z cvi‡eb|
C2
Cell G Mouse
Pointer ‡i‡L t
=IF(B2>=8000,B2*45%,IF(B2>=6000,B2*35%,IF(B2>=4000,B2*22%,B2*15%)))
D2
Cell G Mouse
Pointer ‡i‡L t
=IF(B2>=8000,B2*40%,IF(B2>=4500,B2*28%,B2*18%))
E2
Cell G Mouse
Pointer ‡i‡L t
=IF(B2>=8000,B2*34%,B2*22%)
F2
Cell G Mouse
Pointer ‡i‡L t
=SUM(B2.E2) A_ev =B2+C2+D2+E2
G2
Cell G Mouse
Pointer ‡i‡L t
=B2*12%
H2
Cell G Mouse
Pointer ‡i‡L t
=IF(B2<5000,0,IF(B2<8000,(B2-5000)*1%,(B2-5000)*2%+90))
I2
Cell G Mouse
Pointer ‡i‡L t
=IF(B2>=7000,B2*22%,B2*8%)
J2
Cell G Mouse
Pointer ‡i‡L t
=SUM(G2.I2) A_ev =G2+H2+I2
K2 Cell G Mouse Pointer ‡i‡L t
=+F2-J2
To Copy The Formula (dg©~jv Kwc Kiv) t GKwU welq wbðqB †Lqvj K‡i‡Qb Avgiv m~Î cÖ‡qv‡Mi
gva¨‡g ïaygvÎ †Kqv
bv‡gi †eZ‡bi wnmve Kijvg| wKš‘ wb‡Pi
w`‡K we`¨gvb Ab¨vb¨‡`i wnmv‡ei wK n‡e? hw` ejv nq mevi wnmveB m~Î
cª‡qv‡Mi gva¨‡g Ki‡Z n‡e Zvn‡j Aek¨B
fq cv‡eb| hw` cuvP nvRvi †jvK _v‡K Zvn‡j LyeB mgm¨v ZvB bv? Gevi
Avgiv wkLe wKfv‡e Lye Kg mg‡q m~Î Kwc
Kivi gva¨‡g mevi wnmve †ei Kiv hvq| wewfboe c×wZ‡Z Avgiv KvRwU Ki‡Z
cvwi| Rvbv bv _vK‡j me¸‡jv c×wZ
wk¶‡Ki wbKU †_‡K †R‡b wbb|
No comments:
Post a Comment