assalamu'alaikum berikut saya lampirkan filenya om kid apa ada yang salah dengan rumusnya Terima kasihwassalamu'alaikumfahmi
Pada Selasa, 21 Februari 2017 21:40, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Wa'alaikumussalam wr wb Hai Fahmi, Sebaiknya diperiksa ulang lagi formula yang dibuar tersebut. Wassalamu'alaikum wr wb Kid 2017-02-21 21:19 GMT+07:00 Fahmi Syaifullah fahmisyaifulla...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: Assalamualaikum.Dear BeExceller mau tanya fungsi "and" kenapa ngaco yaa jika tidak diletakkan di field row yg tdk sama pada rujukan fungsinya (data yg dijadiin rumus itu satu row sama rumusnya baru bernilai valid) tapi kalau dilain row (data ada di row 13 dan rumus ditulis di row 17 )hasil output bernilai FALSE padahal jelas2 itu bernilai TRUE. Apa memang seperti itu ya?..Mohon bantuannya.. Terima kasihWassalamu'alaikumfahmi Dikirim dari Yahoo Mail di Android #yiv3816443514 #yiv3816443514 -- #yiv3816443514ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3816443514 #yiv3816443514ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3816443514 #yiv3816443514ygrp-mkp #yiv3816443514hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3816443514 #yiv3816443514ygrp-mkp #yiv3816443514ads {margin-bottom:10px;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad {padding:0 0;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad p {margin:0;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad a {color:#0000ff;text-decoration:none;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc {font-family:Arial;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc #yiv3816443514hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc .yiv3816443514ad {margin-bottom:10px;padding:0 0;}#yiv3816443514 #yiv3816443514actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3816443514 #yiv3816443514activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3816443514 #yiv3816443514activity span {font-weight:700;}#yiv3816443514 #yiv3816443514activity span:first-child {text-transform:uppercase;}#yiv3816443514 #yiv3816443514activity span a {color:#5085b6;text-decoration:none;}#yiv3816443514 #yiv3816443514activity span span {color:#ff7900;}#yiv3816443514 #yiv3816443514activity span .yiv3816443514underline {text-decoration:underline;}#yiv3816443514 .yiv3816443514attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3816443514 .yiv3816443514attach div a {text-decoration:none;}#yiv3816443514 .yiv3816443514attach img {border:none;padding-right:5px;}#yiv3816443514 .yiv3816443514attach label {display:block;margin-bottom:5px;}#yiv3816443514 .yiv3816443514attach label a {text-decoration:none;}#yiv3816443514 blockquote {margin:0 0 0 4px;}#yiv3816443514 .yiv3816443514bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3816443514 .yiv3816443514bold a {text-decoration:none;}#yiv3816443514 dd.yiv3816443514last p a {font-family:Verdana;font-weight:700;}#yiv3816443514 dd.yiv3816443514last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3816443514 dd.yiv3816443514last p span.yiv3816443514yshortcuts {margin-right:0;}#yiv3816443514 div.yiv3816443514attach-table div div a {text-decoration:none;}#yiv3816443514 div.yiv3816443514attach-table {width:400px;}#yiv3816443514 div.yiv3816443514file-title a, #yiv3816443514 div.yiv3816443514file-title a:active, #yiv3816443514 div.yiv3816443514file-title a:hover, #yiv3816443514 div.yiv3816443514file-title a:visited {text-decoration:none;}#yiv3816443514 div.yiv3816443514photo-title a, #yiv3816443514 div.yiv3816443514photo-title a:active, #yiv3816443514 div.yiv3816443514photo-title a:hover, #yiv3816443514 div.yiv3816443514photo-title a:visited {text-decoration:none;}#yiv3816443514 div#yiv3816443514ygrp-mlmsg #yiv3816443514ygrp-msg p a span.yiv3816443514yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3816443514 .yiv3816443514green {color:#628c2a;}#yiv3816443514 .yiv3816443514MsoNormal {margin:0 0 0 0;}#yiv3816443514 o {font-size:0;}#yiv3816443514 #yiv3816443514photos div {float:left;width:72px;}#yiv3816443514 #yiv3816443514photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3816443514 #yiv3816443514photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3816443514 #yiv3816443514reco-category {font-size:77%;}#yiv3816443514 #yiv3816443514reco-desc {font-size:77%;}#yiv3816443514 .yiv3816443514replbq {margin:4px;}#yiv3816443514 #yiv3816443514ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3816443514 #yiv3816443514ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3816443514 #yiv3816443514ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3816443514 #yiv3816443514ygrp-mlmsg select, #yiv3816443514 input, #yiv3816443514 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3816443514 #yiv3816443514ygrp-mlmsg pre, #yiv3816443514 code {font:115% monospace;}#yiv3816443514 #yiv3816443514ygrp-mlmsg * {line-height:1.22em;}#yiv3816443514 #yiv3816443514ygrp-mlmsg #yiv3816443514logo {padding-bottom:10px;}#yiv3816443514 #yiv3816443514ygrp-msg p a {font-family:Verdana;}#yiv3816443514 #yiv3816443514ygrp-msg p#yiv3816443514attach-count span {color:#1E66AE;font-weight:700;}#yiv3816443514 #yiv3816443514ygrp-reco #yiv3816443514reco-head {color:#ff7900;font-weight:700;}#yiv3816443514 #yiv3816443514ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov li a {font-size:130%;text-decoration:none;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov ul {margin:0;padding:0 0 0 8px;}#yiv3816443514 #yiv3816443514ygrp-text {font-family:Georgia;}#yiv3816443514 #yiv3816443514ygrp-text p {margin:0 0 1em 0;}#yiv3816443514 #yiv3816443514ygrp-text tt {font-size:120%;}#yiv3816443514 #yiv3816443514ygrp-vital ul li:last-child {border-right:none !important;}#yiv3816443514
and fungsion.xlsx
Description: MS-Excel 2007 spreadsheet