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
#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
