Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintakisi 1 Sintaksisi2 Öyrəndim

1 If
2 Switch
3 ifs
4 And
5 Xor
6 Or
7 Iferror
8 Ifna
9 Not
10 1
11 0
Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintaksisi2
1 Bahttext ห้าบาทถว้ น 5
2 Char _x0013_ 19
3 Code 19 _x0013_
4 Clean Mirzeyev Mirzeyev
5 Concatenate Iqbal Mirzeyev Iqbal Mirzeyev
6 Concat A2 A1 A2 A1
7 Textjoin A2-A1 A2 A1
8 Dollar 2,00 ₼ 2
9 Exact 1 Iqbal Mirzeyev Iqbal Mirzeyev
10 Find 11 Iqbal Mirzeyev
11 Search 11 Iqbal Mirzeyev
12 Fixed 5 155 515 151,501 5155515151.5005
13 Left #Bilik #BilikPaylasdiqcaArtar
14 Right Artar #BilikPaylasdiqcaArtar
15 Len 22 #BilikPaylasdiqcaArtar
16 Lower #bilikpaylasdiqcaartar #BilikPaylasdiqcaArtar
17 Mid bal Iqbal Mirzeyev
18 NumberValue 5555.5 5,555.5
19 Value 8 8
20 Value 888 888
21 Proper İqbal Mirzeyev iqbal mirzeyev
22 Replace Bilik Paylaşdiqca Artar Bilik Paylashdiqca Artar
23 Rept 999999999 9
24 Substitute Bilik Paylaşdiqca Artar Bilik Paylashdiqca Artar
25 T Hi Hi
26 Text Yan.22.07 44568
27 Trim Iqbal Mirzeyev Iqbal Mirzeyev
28 Upper BİLİK PAYLASDİQCA ARTAR bilik paylasdiqca artar
Öyrəndim
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintakisi 1
1 Date 44839 2022 10
2 DateValue 44569 44569
3 Day 8 44569
4 Month 1 44569
5 Year 2022 44569
6 Hour 14 0.6201388888889
7 Minute 54 0.6208333333333
8 Second 6 0.6209027777778
9 Days 4586 44569
10 Days360 -4519 44569
11 YearFrac 7 44570
12 Edate 44660 44570
13 EoMonth 44592 44570
14 Now 44784.678069218
15 Today 44784
16 WeekDay 6 44569
17 Weeknum 2 44569
18 IsoWeeknum 1 44569
19 NetWorkDays 260 44569 44934
20 NetWorkDays.INTL 313 44569 44934
21 Time 0.642534722222222
22 TimeValue 0.705381944444444
23 Workday 44603 44570
24 Workday.INTL 44582 44570
Sintaksisi2 Öyrəndim
5 +
+
+
+
+
+
+
+
39983 +
39983 +
47127 +
+
+
+
+
+
+
+
43988 +
43988 +
+
+
43556 +
43556 +
Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintaksisi 2
f Address
2 Areas
3 Column 4
4 Columns 3
5 Row 6
6 Rows 1
7 Filter
8 Sort
9 Sortby
10 Convert 4535923.7 5
10 Unique
11 FormulaText =ROWS(D7:F7)
12 Indirect
13 Getpivotdata
14 Hyberlink #N/A #N/A
15 Transpose
16 Offset
17 Match
18 Xmatch
19 Index
20 Vlookup
21 Lookup
22 Hlookup
23 Xlookup
24 Choose 12 Dekabr
25 Rtd
Sintaksisi 3 Öyrəndim
+
+
+
+
+
+

+
+

+
+

+
Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintakisi 1
1 Cell 5 5
2 Error.type 2 #DIV/0!
3 Info LINUX
4 Isblank 1
5 Iserr 0 5 5
6 Iserror 1 5
7 Iseven 1 6
8 Isodd 0 6
9 Isformula 1 6 5
10 Islogical 0 if
11 Isna 1 #N/A
12 Isnontext 1
13 Isnumber 1 4
14 Isref 0
15 Istext 1 innab
16 N 0.9548611111111 22:55
17 Na #N/A
18 Sheet 5
19 Sheets 11
20 Type 1
Sintaksisi2 Öyrəndim
+
+
+
+
1 +
#DIV/0! +
+
+
30 +
+
+
+
+
+
+
+
+
+
+
+
Sıra nömrəsi Funksiyanın adı Funksiya Sintaksisi Sintaksisi 1
1 Abs 5 -5
2 Acos
3 Acosh
4 Acot
5 Acoth
6 Aggregate
7 Arabic 215 CCXV
8 Asin
9 Asinh
10 Atan
11 Atan2
12 Atanh
13 Base
14 Ceiling.Math 61523 6734
15 Combing 10
16 Combina
17 Cos
18 Cosh
19 Cot
20 Coth
21 Csc
22 Csch
23 Decimal
24 Degrees
25 Exp
26 Even 6 5.50
27 Fact 120 5
28 FactDouble
29 Floor.Math 54 55
30 Gcd 5 15 25
31 Trunc 25 25
32 Int 25 25.5
33 Quotient 5 25
34 Lcm 75 15 25
35 Ln
36 Log
37 Log10
38 Mideterm
39 Minverse
40 Mmult
41 Mod 1 25
42 Mround 48 6
43 Multinomal
44 Munit
45 Odd 7 6.60
46 Pi 3.14159265358979
47 Power 262144
48 Product
49 Radians
50 Rand 0.558615211958758
51 RandBetween 845180395
52 Roman CCXV 215
53 Round 25.5
54 RoundDown 25.5
55 RoundUp 25.6
56 Sec
57 Sech
58 Seriessum
59 Sign 1 5
60 Sin
61 Sinh
62 Sqrt 8 64
63 SqrtPi
64 Subtotal 11 5 6
65 Sumif
66 Sumifs
67 SumProduct 25 5 6
68 SumSq 50 5 6
69 Tan
70 Tanh
71 Sum 11 5 6
72 SumMx2My2
73 SumX2Py2
74 SumXMY2
75 Sum
Sintaksisi 2 Öyrəndim
+

24

+
+

+
+

+
+
+
+
+
+

+
+
+
+

+
25.52 +
25.52 +
25.52 +

+
+
+
+

+
Sıra Nömrəsi Funksiyanin adi Funksiya Sintaksisi Sintakisi 1 Sintaksisi2
1 Average
2 Averagea
3 Averageif
4 Averageifs
5 Geoman
6 Harmean
7 Trimmean
8 Mode
9 Median
10 Percentile
11 Rank
12 Count 2 5 6n
13 Counta 3 5n 6
14 Countif
15 Countifs
16 Countblank
17 Large 5 5 6
18 Small 6 6 5
19 Max 0 1 0
20 Maxa 1 1 0
21 Min 5 5 6
22 Mina 5 5 6
23 Maxifs
24 minifs
25 Frequency
26 Stdev.P
27 StdevPa
28 Stdev.S
29 Stdeva
30 Covariance.S
31 Covariance.P
32 Correl
Öyrəndim
+
+
+
+

+
+
+
+
+
+
+
+
+
+
+
+
Sıra Nömrəsi Funksiyanın adı Funksiya Sintaksisi Sintaksisi 2 Öyrəndim
1 Dmax +
2 Dmaxa +
3 Dmin +
4 Dcount +
5 Cdounta +
6 Dsum +
7 Dproduct +
8 Daverage +
9 Dget +