İÇİNDEKİLER
Formüller
değerleri nasıl hesaplar?....................................................................................................................................................... 1
Formül sözdizimi hakkında................................................................................................................................................................... 11
Çalışma sayfası işlevleri hakkında...................................................................................................................................................... 11
Formül sözdizimi hakkında................................................................................................................................................................... 11
Formülü düzenleme............................................................................................................................................................................... 11
Dizi formülünü düzenleme................................................................................................................................................................... 12
Formülün tümünü veya parçasını hesaplanan değerle değiştirme................................................................................................ 12
Formülü veya dizi formülünü silme.................................................................................................................................................... 12
Hücre ve aralık başvuruları hakkında................................................................................................................................................. 12
Göreceli ve mutlak başvuruların arasındaki fark............................................................................................................................... 13
R1C1 başvuruları hakkında.................................................................................................................................................................. 13
Çok sayıdaki sayfada aynı hücreye veya aralığa 3-B başvuru kullanarak
başvurma................................................................. 14
3-B başvuruları kullanma yönergeleri................................................................................................................................................ 14
Çalışma sayfalarını taşıdığınızda, kopyaladığınızda, eklediğinizde veya
sildiğinizde 3-B başvuruya ne olur?....................... 14
Dizi formülleri ve nasıl girilecekleri hakkında.................................................................................................................................... 14
Çalışma kitaplarındaki hesaplamalar hakkında.................................................................................................................................. 15
Diğer çalışma sayfalarındaki veya çalışma kitaplarındaki değerleri
hesaplamak için formüller kullanma hakkında................ 15
TARİH VE SAAT FONKSİYONLARI............................................................................................................................................... 16
BUGÜN.............................................................................................................................................................................................. 16
TARİH................................................................................................................................................................................................ 16
BUGÜN.............................................................................................................................................................................................. 17
GÜN.................................................................................................................................................................................................... 17
ŞİMDİ................................................................................................................................................................................................. 17
TARİHSAYISI.................................................................................................................................................................................. 17
ZAMANSAYISI............................................................................................................................................................................... 18
DAKİKA............................................................................................................................................................................................ 18
YIL...................................................................................................................................................................................................... 18
HAFTANINGÜNÜ........................................................................................................................................................................... 19
SAAT................................................................................................................................................................................................. 19
AY....................................................................................................................................................................................................... 20
SERİTARİH....................................................................................................................................................................................... 20
TAMİŞGÜNÜ................................................................................................................................................................................... 20
SERİAY.............................................................................................................................................................................................. 21
HAFTASAY...................................................................................................................................................................................... 21
İŞGÜNÜ............................................................................................................................................................................................. 22
METİN FONKSİYONLARI............................................................................................................................................................. 22
DAMGA............................................................................................................................................................................................ 22
TEMİZ................................................................................................................................................................................................ 22
KOD.................................................................................................................................................................................................... 23
BİRLEŞTİR........................................................................................................................................................................................ 23
LİRA................................................................................................................................................................................................... 23
ÖZDEŞ............................................................................................................................................................................................... 24
BUL..................................................................................................................................................................................................... 24
SAYIDÜZENLE................................................................................................................................................................................ 24
SOLDAN............................................................................................................................................................................................ 25
UZUNLUK......................................................................................................................................................................................... 25
KÜÇÜKHARF................................................................................................................................................................................... 25
PARÇAAL......................................................................................................................................................................................... 26
YAZIM.DÜZENİ.............................................................................................................................................................................. 26
DEĞİŞTİR.......................................................................................................................................................................................... 26
YİNELE............................................................................................................................................................................................... 27
SAĞDAN........................................................................................................................................................................................... 27
MBUL................................................................................................................................................................................................. 27
MBUL($B$17;$A$14) eşittir 5......................................................................................................................................................... 28
YERİNEKOY...................................................................................................................................................................................... 28
M......................................................................................................................................................................................................... 28
METNEÇEVİR................................................................................................................................................................................... 29
KIRP................................................................................................................................................................................................... 29
Örnek.................................................................................................................................................................................................. 29
BÜYÜKHARF................................................................................................................................................................................... 29
SAYIYAÇEVİR................................................................................................................................................................................. 29
MATEMATİKSEL FONKSİYONLAR.............................................................................................................................................. 30
MUTLAK.......................................................................................................................................................................................... 30
TAVANAYUVARLA...................................................................................................................................................................... 30
COS..................................................................................................................................................................................................... 30
EĞERSAY.......................................................................................................................................................................................... 30
EĞERSAY(A3:A6;”elmalar”) eşittir 2............................................................................................................................................ 31
ÇİFT.................................................................................................................................................................................................... 31
ÜS....................................................................................................................................................................................................... 31
ÇARPINIM........................................................................................................................................................................................ 31
TABANAYUVARLA...................................................................................................................................................................... 31
OBEB.................................................................................................................................................................................................. 32
TAMSAYI......................................................................................................................................................................................... 32
OKEK................................................................................................................................................................................................. 32
LN....................................................................................................................................................................................................... 33
LOG..................................................................................................................................................................................................... 33
LOG10................................................................................................................................................................................................. 33
MOD................................................................................................................................................................................................... 33
KYUVARLA...................................................................................................................................................................................... 33
TEK..................................................................................................................................................................................................... 34
Pİ......................................................................................................................................................................................................... 34
ÇARPIM............................................................................................................................................................................................ 34
BÖLÜM.............................................................................................................................................................................................. 35
S_SAYI_ÜRET................................................................................................................................................................................. 35
RASGELEARADA........................................................................................................................................................................... 35
ROMEN.............................................................................................................................................................................................. 35
YUVARLA......................................................................................................................................................................................... 36
AŞAĞIYUVARLA............................................................................................................................................................................ 36
YUKARIYUVARLA......................................................................................................................................................................... 36
İŞARET.............................................................................................................................................................................................. 37
SİN...................................................................................................................................................................................................... 37
KAREKÖK........................................................................................................................................................................................ 37
ALTTOPLAM................................................................................................................................................................................... 37
TOPLA............................................................................................................................................................................................... 38
ETOPLA............................................................................................................................................................................................. 38
TAN.................................................................................................................................................................................................... 39
NSAT................................................................................................................................................................................................. 39
VE........................................................................................................................................................................................................ 39
VE(B1:B3) eşittir YANLIŞ................................................................................................................................................................ 39
VE(1<B4; B4<100) eşittir DOĞRU.................................................................................................................................................. 40
YANLIŞ.............................................................................................................................................................................................. 40
EĞER................................................................................................................................................................................................... 40
DEĞİL................................................................................................................................................................................................. 41
YADA................................................................................................................................................................................................ 41
DOĞRU.............................................................................................................................................................................................. 41
MİN.................................................................................................................................................................................................... 41
ORTANCA........................................................................................................................................................................................ 42
MAK.................................................................................................................................................................................................. 42
ORTALAMA.................................................................................................................................................................................... 42
BİLGİ FONKSİYONLARI.................................................................................................................................................................... 43
HÜCRE............................................................................................................................................................................................... 43
BOŞLUKSAY.................................................................................................................................................................................... 44
HATA.TİPİ........................................................................................................................................................................................ 44
BİLGİ.................................................................................................................................................................................................. 45
E İşlevleri........................................................................................................................................................................................... 45
EÇİFTSE............................................................................................................................................................................................. 46
ETEKSE.............................................................................................................................................................................................. 47
S.......................................................................................................................................................................................................... 47
YOKSAY............................................................................................................................................................................................ 47
TİP...................................................................................................................................................................................................... 48
ARAMA VE BAŞVURU İŞLEVLERİ................................................................................................................................................. 48
ADRES............................................................................................................................................................................................... 48
ALANSAY........................................................................................................................................................................................ 49
SÜTUN............................................................................................................................................................................................... 49
SÜTUNS