Y\u00f6ntem 1: Bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/strong><\/span><\/p>\n A1<\/strong> h\u00fccresi bo\u015fsa bu form\u00fcl “Bo\u015f” de\u011ferini d\u00f6nd\u00fcr\u00fcr, de\u011filse form\u00fcl “Bo\u015f de\u011fil” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Y\u00f6ntem 2: Birden fazla h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/strong><\/span><\/p>\n A1<\/strong> ve B1<\/strong> h\u00fccrelerinin her ikisi de bo\u015fsa bu form\u00fcl “Bo\u015f” de\u011ferini d\u00f6nd\u00fcr\u00fcr. Aksi takdirde “Bo\u015f De\u011fil” sonucunu d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler Excel’de her y\u00f6ntemin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Diyelim ki Excel’de farkl\u0131 basketbol oyuncular\u0131n\u0131n att\u0131\u011f\u0131 say\u0131 say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz:<\/span> <\/p>\n A s\u00fctunundaki her h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanaca\u011f\u0131z:<\/span><\/p>\n Bu form\u00fcl\u00fc B2<\/strong> h\u00fccresine yazaca\u011f\u0131z, ard\u0131ndan kopyalay\u0131p B s\u00fctununda kalan her h\u00fccreye yap\u0131\u015ft\u0131raca\u011f\u0131z:<\/span> <\/p>\n B s\u00fctunundaki de\u011ferler bize A s\u00fctununda kar\u015f\u0131l\u0131k gelen her de\u011ferin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 s\u00f6yler.<\/span><\/p>\n Excel’de a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n A ve B s\u00fctunlar\u0131ndaki h\u00fccrelerin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanaca\u011f\u0131z:<\/span><\/p>\n Bu form\u00fcl\u00fc C2<\/strong> h\u00fccresine girece\u011fiz, ard\u0131ndan kopyalay\u0131p C s\u00fctununda kalan her h\u00fccreye yap\u0131\u015ft\u0131raca\u011f\u0131z:<\/span> <\/p>\n C s\u00fctunundaki de\u011ferler bize A s\u00fctunu ve B s\u00fctununda kar\u015f\u0131l\u0131k gelen iki de\u011ferin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 s\u00f6yler.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: Aral\u0131\u011f\u0131n belirli bir de\u011fer i\u00e7erip i\u00e7ermedi\u011fi nas\u0131l kontrol edilir<\/a> Excel’de h\u00fccrelerin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanabilirsiniz: Y\u00f6ntem 1: Bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin = IF ( ISBLANK ( A1 ) , “Empty” , “Not Empty” ) A1 h\u00fccresi bo\u015fsa bu form\u00fcl “Bo\u015f” de\u011ferini d\u00f6nd\u00fcr\u00fcr, de\u011filse form\u00fcl “Bo\u015f de\u011fil” de\u011ferini d\u00f6nd\u00fcr\u00fcr. Y\u00f6ntem 2: Birden fazla h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4139","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =<\/span> IF<\/span> (<\/span> ISBLANK<\/span> (<\/span> A1<\/span> )<\/span> ,<\/span> \"Empty\"<\/span> ,<\/span> \"Not Empty\"<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n =<\/span> IF<\/span> (AND(<\/span> ISBLANK<\/span> (<\/span> A1<\/span> ), ISBLANK( B1<\/span> ))<\/span> ,<\/span> \u201cEmpty\u201d<\/span> ,<\/span> \u201cNot Empty\u201d<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n \u00d6rnek 1: Bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty1.png\"){kind=spacer}
<\/p>\n =<\/span> IF<\/span> (<\/span> ISBLANK<\/span> (<\/span> A2<\/span> )<\/span> ,<\/span> \"Empty\"<\/span> ,<\/span> \"Not Empty\"<\/span> )<\/span><\/strong><\/span><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty2.png\")
<\/p>\n \u00d6rnek 2: Birden fazla h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty3.png\"){kind=spacer}
<\/p>\n =<\/span> IF<\/span> (AND(<\/span> ISBLANK<\/span> (<\/span> A2<\/span> ), ISBLANK( B2<\/span> ))<\/span> ,<\/span> \u201cEmpty\u201d<\/span> ,<\/span> \u201cNot Empty\u201d<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: h\u00fccrenin k\u0131smi metin i\u00e7erip i\u00e7ermedi\u011fini kontrol etme<\/a>
Excel: Ba\u015fka bir s\u00fctunda bir s\u00fctun de\u011ferinin bulunup bulunmad\u0131\u011f\u0131 nas\u0131l kontrol edilir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"