waalaikum salam...
ini percobaan analisis dari seorang pemula...hehe...
sepertinya formula yang anda buat itu salah penggunaan... sepanjang pengetahuan
saya formula and itu dalam penulisan logika dasar nya tidak mengandung blok
array, tp mengapa dalam penulisan formula anda mengandung blok array.... ?
setelah saya coba dengan membuang blok array nya dengan menuliskan
=AND(B2=$H$1;C2=$I$1)saya dapat memasangnya dimana saja. br,
odong nando
Dari: "Fahmi Syaifullah [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Rabu, 22 Februari 2017 8:41
Judul: Bls: [belajar-excel] Logika AND [1 Attachment]
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' [email protected]
[belajar-excel]" <[email protected]> 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 [email protected]
[belajar-excel] <[email protected]>:
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
#yiv9749555721 #yiv9749555721 -- #yiv9749555721ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9749555721
#yiv9749555721ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9749555721
#yiv9749555721ygrp-mkp #yiv9749555721hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9749555721 #yiv9749555721ygrp-mkp #yiv9749555721ads
{margin-bottom:10px;}#yiv9749555721 #yiv9749555721ygrp-mkp .yiv9749555721ad
{padding:0 0;}#yiv9749555721 #yiv9749555721ygrp-mkp .yiv9749555721ad p
{margin:0;}#yiv9749555721 #yiv9749555721ygrp-mkp .yiv9749555721ad a
{color:#0000ff;text-decoration:none;}#yiv9749555721 #yiv9749555721ygrp-sponsor
#yiv9749555721ygrp-lc {font-family:Arial;}#yiv9749555721
#yiv9749555721ygrp-sponsor #yiv9749555721ygrp-lc #yiv9749555721hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9749555721
#yiv9749555721ygrp-sponsor #yiv9749555721ygrp-lc .yiv9749555721ad
{margin-bottom:10px;padding:0 0;}#yiv9749555721 #yiv9749555721actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9749555721
#yiv9749555721activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9749555721
#yiv9749555721activity span {font-weight:700;}#yiv9749555721
#yiv9749555721activity span:first-child
{text-transform:uppercase;}#yiv9749555721 #yiv9749555721activity span a
{color:#5085b6;text-decoration:none;}#yiv9749555721 #yiv9749555721activity span
span {color:#ff7900;}#yiv9749555721 #yiv9749555721activity span
.yiv9749555721underline {text-decoration:underline;}#yiv9749555721
.yiv9749555721attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9749555721 .yiv9749555721attach div a
{text-decoration:none;}#yiv9749555721 .yiv9749555721attach img
{border:none;padding-right:5px;}#yiv9749555721 .yiv9749555721attach label
{display:block;margin-bottom:5px;}#yiv9749555721 .yiv9749555721attach label a
{text-decoration:none;}#yiv9749555721 blockquote {margin:0 0 0
4px;}#yiv9749555721 .yiv9749555721bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9749555721
.yiv9749555721bold a {text-decoration:none;}#yiv9749555721 dd.yiv9749555721last
p a {font-family:Verdana;font-weight:700;}#yiv9749555721 dd.yiv9749555721last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9749555721
dd.yiv9749555721last p span.yiv9749555721yshortcuts
{margin-right:0;}#yiv9749555721 div.yiv9749555721attach-table div div a
{text-decoration:none;}#yiv9749555721 div.yiv9749555721attach-table
{width:400px;}#yiv9749555721 div.yiv9749555721file-title a, #yiv9749555721
div.yiv9749555721file-title a:active, #yiv9749555721
div.yiv9749555721file-title a:hover, #yiv9749555721 div.yiv9749555721file-title
a:visited {text-decoration:none;}#yiv9749555721 div.yiv9749555721photo-title a,
#yiv9749555721 div.yiv9749555721photo-title a:active, #yiv9749555721
div.yiv9749555721photo-title a:hover, #yiv9749555721
div.yiv9749555721photo-title a:visited {text-decoration:none;}#yiv9749555721
div#yiv9749555721ygrp-mlmsg #yiv9749555721ygrp-msg p a
span.yiv9749555721yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9749555721
.yiv9749555721green {color:#628c2a;}#yiv9749555721 .yiv9749555721MsoNormal
{margin:0 0 0 0;}#yiv9749555721 o {font-size:0;}#yiv9749555721
#yiv9749555721photos div {float:left;width:72px;}#yiv9749555721
#yiv9749555721photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9749555721
#yiv9749555721photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9749555721
#yiv9749555721reco-category {font-size:77%;}#yiv9749555721
#yiv9749555721reco-desc {font-size:77%;}#yiv9749555721 .yiv9749555721replbq
{margin:4px;}#yiv9749555721 #yiv9749555721ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9749555721 #yiv9749555721ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9749555721
#yiv9749555721ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9749555721
#yiv9749555721ygrp-mlmsg select, #yiv9749555721 input, #yiv9749555721 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9749555721
#yiv9749555721ygrp-mlmsg pre, #yiv9749555721 code {font:115%
monospace;}#yiv9749555721 #yiv9749555721ygrp-mlmsg *
{line-height:1.22em;}#yiv9749555721 #yiv9749555721ygrp-mlmsg #yiv9749555721logo
{padding-bottom:10px;}#yiv9749555721 #yiv9749555721ygrp-msg p a
{font-family:Verdana;}#yiv9749555721 #yiv9749555721ygrp-msg
p#yiv9749555721attach-count span {color:#1E66AE;font-weight:700;}#yiv9749555721
#yiv9749555721ygrp-reco #yiv9749555721reco-head
{color:#ff7900;font-weight:700;}#yiv9749555721 #yiv9749555721ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9749555721 #yiv9749555721ygrp-sponsor
#yiv9749555721ov li a {font-size:130%;text-decoration:none;}#yiv9749555721
#yiv9749555721ygrp-sponsor #yiv9749555721ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9749555721
#yiv9749555721ygrp-sponsor #yiv9749555721ov ul {margin:0;padding:0 0 0
8px;}#yiv9749555721 #yiv9749555721ygrp-text
{font-family:Georgia;}#yiv9749555721 #yiv9749555721ygrp-text p {margin:0 0 1em
0;}#yiv9749555721 #yiv9749555721ygrp-text tt {font-size:120%;}#yiv9749555721
#yiv9749555721ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9749555721
