13- এক্সেলের সূত্র প্রয়োগ করে কতিপয় গাণিতিক সমাধান
wewfbœ kx‡Ui KvR : [ Kx fv‡e BbKvg‡U· †ei Kiv hvq ]
*Kvnv‡iv †eZb 5,000n‡Z 10,000/-Gi g‡a¨ 2%Ges 10,000/-UvKvi †ewk n‡j 5%BbKvg †U· w`‡Z n‡e |Gk‡ã bv cvi‡j Zvi †U· w`‡Z
n‡e bv | A_vr m~‡Î H †m‡j none ‡jLv Avm‡e | G kZ©wU wb‡¤œi m~‡Î cÖ‡qvM Ki‡ev |
=IF(AND
(B3>5000,B3<10000),B3*2%, IF(B3>10000,B3*5%, “None” ))
A
|
B
|
C
|
|
1.
|
IncomeTax
|
||
2.
|
Name
|
Salary
|
Tax
|
3.
|
Alam
|
25000
|
1250
|
4.
|
Afroza
|
1000
|
None
|
5.
|
Runa
|
8000
|
160
|
be Kw¤úDUvi
GÛ d‡UvKwc, cyivZb evmó¨Û, gvae`x nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-27
wewfbœ kx‡Ui KvR : [ Kx fv‡e kÖwgK‡`i
gyRyix †ei Kiv hvq ]
aiv hvK †Kvb GK †Kv¤úvwb cÖwZ N›Uv wn‡m‡e Zvi kÖwgK‡`i gRyix cÖ`vb
K‡ib| †Kvb kÖwgK hw` ˆ`wbK 10 N›Uv Zvi †P‡q Kg KvR K‡i Zv n‡j Zvi gyRyix N›Uv
cÖwZ 30 UvKv ˆ`wbK 10 N›Uv †ekx KvR Ki‡j Zvi AwZwi³ N›Uvi gyRyix 40 UvKv| A_v©r
†m 12 N›Uv KvR Ki‡j cv‡e 10* 30=300+(2*40) = 380 UvKv Wage Sheet e¨envi
K‡i Avcwb Lye mn‡R †h †Kvb cwigvY N›Uvi gyRyix †ei Ki‡Z cv‡ib|
=IF(C5<=10,C5*30,IF(C5<10,(C5-10)*40+10*30))
FX
|
=IF(C5<=10,C5*30,IF(C5<10,(C5-10)*40+10*30))
|
||||
A
|
B
|
C
|
D
|
||
1
|
Wage Sheet
|
||||
2
|
ID NO.
|
Name
|
Working
Hour
|
Payment
|
|
3
|
6057
|
Aslam
|
8
|
||
4
|
6058
|
Momin
|
12
|
||
5
|
6059
|
Kuddus
|
5
|
150
|
|
6
|
6060
|
Arman
|
14
|
460
|
|
7
|
6061
|
Habib
|
12
|
380
|
|
8
|
6062
|
Latif
|
6
|
180
|
|
9
|
6063
|
Kamrul
|
8
|
240
|
|
10
|
6064
|
Monirul
|
13
|
420
|
|
be Kw¤úDUvi GÛ d‡UvKwc,
cyivZb evmó¨Û, gvae`x nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-28
wewfbœ kx‡Ui KvR : [ Kx fv‡e ‡iRvë
†ei Kiv hvq ]
Result Sheet
Qv‡Îi µwgK , bvg I †gvU bv¤^vi Gi Dci wfwË K‡I
wb‡Pi †iRvëkxUwU ˆZix Kiv n‡q‡Q | A_v©r800Gi mgvb ev †ewk bv¤^vi †c‡j = star, 600 = Gi
mgvb ev †ewk bv¤^vi †c‡j = 1st , 580 Gi
mgvb ev †ewk †c‡j -2nd, 550= &&&&&&Gi mgvb ev
†ewk †c‡j -3rd,bZzev †dj †`Lv‡e |
wKš‘ †Kn hw` 800 bv¤^vi †c‡q †Kv‡bv GKwU mve‡R‡±
20 bv¤^vi Kg cvq Zvn‡j Zv‡K †dj †`Lv‡bv cÖ‡qvRb | GgZve¯’vq Dc‡ii m~ÎwU wVK
_vK‡e Ges Gi 1g As‡k wKQz †jLv †hvM Ki‡Z n‡e :
wb‡¤œi m~ÎwU †`Lyb|
= IF(OR(C3<33,D3<33,E3<33,F3<33,G3<33,
H3<33,I3<33,J3<33,K3 <33, L3<33), "Fail",IF(M3>=
800,"Star",IF(M3>=600,"1st",IF(M3>=580,
"2nd", IF (M3>550, "3rd","Fail")))))
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
||
FX
|
= IF(OR(C3<33,D3<33,E3<33,F3<33,G3<33,
H3<33,I3<33,J3<33,K3 <33,L3<33),"Fail",IF(M3>= 800, "Star", IF(M3>=600,"1st",IF(M3>=580,
"2nd", IF (M3>550, "3rd","Fail")))))
|
|||||||||||||
1
|
Result Sheet
|
|||||||||||||
2
|
R
|
Name
|
B-1
|
B-2
|
E-1
|
E-2
|
Math
|
Geo
|
His
|
Islam
|
Ph.
|
Che
|
Total
|
Result
|
3
|
Samim
|
90
|
88
|
95
|
77
|
50
|
80
|
94
|
90
|
80
|
70
|
814
|
Star
|
|
4
|
Eati
|
88
|
67
|
80
|
68
|
45
|
70
|
84
|
80
|
55
|
75
|
712
|
1st
|
|
5
|
Sabbir
|
65
|
80
|
25
|
70
|
55
|
60
|
74
|
75
|
55
|
40
|
599
|
Fail
|
|
6
|
Nazrul
|
77
|
95
|
45
|
55
|
65
|
50
|
64
|
65
|
55
|
40
|
611
|
1st
|
|
7
|
Mim
|
45
|
66
|
77
|
67
|
76
|
55
|
54
|
45
|
35
|
40
|
560
|
3rd
|
|
8
|
Basir
|
55
|
77
|
88
|
84
|
75
|
45
|
44
|
35
|
35
|
40
|
578
|
3nd
|
|
9
|
Farhan
|
65
|
70
|
80
|
55
|
48
|
65
|
84
|
44
|
35
|
35
|
581
|
2nd
|
|
wewfbœ kx‡Ui KvR : [ Kx fv‡e we`y¨r
wej †ei Kiv hvq ]
we`y¨r wej ˆZix KiY :we`y¨r LiP 1 †_‡K 20 BDwbU ch©šÍ 1. 75 UvKv , 201
†_‡K 400 BDwbU ch©šÍ 2.50 UvKv ,401 †_‡K 500 BDwbU ch©šÍ 3.00 UvKv Ges Zvi
&&&&&&&&&&&&&&Dc‡i n‡j
4.00UvKv K‡i avh©¨ Kiv nq | G m~ÎwU wb¤œiƒc:
=IF (C3<=200,C3*1.75,IF(C3<=400,C3*2.5,IF(C3<=500,C3*3,C3*4)))
A
|
B
|
C
|
D
|
|
Fx
|
=IF
(C3<=200,C3*1.75,IF(C3<=400,C3*2.5,IF(C3<=500,C3*3,C3*4)))
|
|||
1
|
Electricity
Bill
|
|||
2
|
Name
|
Unit
|
Bill
|
|
3
|
Rehena
|
200
|
350
|
|
4
|
Aonik
|
350
|
875
|
|
4
|
Sabbir
|
490
|
1470
|
|
5
|
Sakil
|
550
|
2200
|
|
[we:: `ª D‡jøL¨ †h , m~Î GKevi UvBc Ki‡jB P‡j | Zvici
m~Î †h †m‡j UvBc Kiv n‡q‡Q †m Ni †_‡K
wb‡Pi w`‡K wm‡j± K‡i Ctrl +D ‡cÖm Ki‡jB Pj‡e |]
be Kw¤úDUvi
GÛ d‡UvKwc, cyivZb evmó¨vÛ, gvae`x nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-29
wewfbœ kx‡Ui KvR : [ Kx fv‡e
†mjvwikxU ˆZix Kiv hvq ]
Salary Sheet
Kg©KZ©v I Kg©Pvwi‡`i Rb¨ Salary Sheet ‰Zix
Ki‡Z n‡e †hLv‡b kZ© n‡jv :-
House Rent ,Basic Gi 50%| (m~Î:=(C2*50%) (D2 ‡m‡j
Kvm©I †i‡L)
P-Fund,
Basic Gi 10%| (m~Î := (C2*10%)(E2 ‡m‡j Kvm©i †i‡L)
‡gwW%fvZv ,
200,T/A-100UvKv
| 200UvKv wd·W, 100 UvKv wd·W
Total Gi m~Î
=SUM (C2:G2)
Net Salary Gi m~Î
= H2- 12 Enter
Gevi wdj †n‡Ûi K‡I wb‡P
wb‡P m~ÎwU Kwc K‡I w`b |
[kZ©
n‡”Q Kvm©i ivL‡Z n‡e †iRvë Gi N‡i |]
SL
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
1
|
Salary Sheet
|
||||||||
2
|
Name
|
Basic
|
HRent-50%
|
Med-5%
|
TA/DA-5%
|
Sub Total
|
PFund-3%
|
Net salary
|
|
3
|
Mahabub
|
25000
|
12500
|
1250
|
1250
|
40000
|
750
|
39250
|
|
4
|
Usama
|
20000
|
10000
|
1000
|
1000
|
32000
|
600
|
31400
|
|
5
|
Sabbir
|
10000
|
5000
|
500
|
500
|
16000
|
300
|
15700
|
|
6
|
Riad
|
8000
|
4000
|
400
|
400
|
12800
|
240
|
12560
|
|
wewfbœ kx‡Ui KvR : [ Kx fv‡e Kwgkb
wbY©q Kiv hvq ]
Kwgkb wbY©q :
†ew·g‡Kv dvg©v :wj:Zv‡`i weµq cÖwZwbwa‡`i weµ‡qi Dci wfwË K‡i Kwgkb
w`‡e | kZ© n‡jv :
hw` weµq 10,000/- UvKvi
Kg nq , Zvn‡j Kwgkb 2%,
30,000/- UvKvi Kg nq
Zvn‡j Kwgkb 5%
50,000/-UvKv ch©šÍ
Kwgkb 7%Ges
50, 000/-UvKvi D‡a© n‡j 10%Kwgkb cv‡e |
GLb †mjmg¨vb ZZ K‡I
Kwgkb cv‡e Zv †ei Kivi Rb¨ wb‡gœi m~ÎwU UvBc Kiæb :
=IF (C3
<=10000, C3*2%, IF (C3<=30000, C3*5%, IF (C3<=50000,C3 *7%, C3*10%)))
FX
|
=IF (C3 <=10000, C3*2%, IF
(C3<=30000, C3*5%, IF (C3<=50000,C3 *7%, C3*10%)))
|
|||
A
|
B
|
C
|
D
|
|
1
|
Commission
|
|||
2
|
SL.NO
|
Sales Person
|
Sales
|
Comission
|
3
|
1
|
Anopam
|
60000
|
6000
|
4
|
2
|
Nad
|
50000
|
3500
|
5
|
3
|
Protima
|
30000
|
1500
|
6
|
4
|
Upoma
|
8000
|
160
|
be Kw¤úDUvi GÛ d‡UvKwc, cyivZb evmó¨vÛ, gvae`x
nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-30