Warning: include_once(/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/wp-cache-phase1.php): failed to open stream: No such file or directory in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/advanced-cache.php on line 22

Warning: include_once(): Failed opening '/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/wp-cache-phase1.php' for inclusion (include_path='.:/opt/php74') in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/advanced-cache.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/advanced-cache.php:22) in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-editormd/src/Main.php on line 113

Warning: include(/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/wp-cache-base.php): failed to open stream: No such file or directory in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-super-cache/wp-cache.php on line 115

Warning: include(): Failed opening '/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/wp-cache-base.php' for inclusion (include_path='.:/opt/php74') in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-super-cache/wp-cache.php on line 115

Warning: include_once(/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/ossdl-cdn.php): failed to open stream: No such file or directory in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-super-cache/wp-cache.php on line 138

Warning: include_once(): Failed opening '/var/www/nurkholis/data/www/nurkholis.web.id/wp-content/plugins/wp-super-cache/ossdl-cdn.php' for inclusion (include_path='.:/opt/php74') in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-super-cache/wp-cache.php on line 138

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/advanced-cache.php:22) in /var/www/nurkholis/data/www/nurkholis.web.id/wp/wp-content/plugins/wp-super-cache/wp-cache-phase2.php on line 1539
Rumus IF dengan Kriteria Memuat Kata Tertentu pada Microsoft Excel | Catatan Nurkholis

Rumus IF dengan Kriteria Memuat Kata Tertentu pada Microsoft Excel

oleh

Pada beberapa waktu yang lalu, ada sebuah pertanyaan seputar rumus Excel IF di mana kriteria yang dicari harus memuat kata tertentu, sementara rumus IF itu sendiri tidak mendukung wildcards. Solusinya, kita kombinasikan dengan rumus-rumus lain yang mendukung wildcards seperti COUNTIF/COUNTIFS

RUMUS UMUM

IF – COUNTIF

=IF(COUNTIF(A1;"*kata*");<jika_benar>;<jika_salah>)

IF – COUNTIFS

=IF(COUNTIFS(A1;"*kata*");<jika_benar>;<jika_salah>)

RUMUS ALTERNATIF

Alternatif lain, tanpa menggunakan wildcard, kita bisa menggunakan gabungan rumus IF-ISNUMBER-FIND/SEARCH

IF – ISNUMBER – FIND

=IF(ISNUMBER(FIND(A1;"kata"));<jika_benar>;<jika_salah>)

IF – ISNUMBER – SEARCH

=IF(ISNUMBER(SEARCH(A1;"kata"));<jika_benar>;<jika_salah>)
Perbedaan kedua rumus tersebut adala, FIND ia memperhatikan kapital, sementara SEARCH tidak memperhatikan kapital.

Tinggalkan komentar

%d blogger menyukai ini: