trimakasih atas ulasan pak guru,
klo dilihat formula index, bila row_num / column_num tidak ter isi keduanya
maka formula tidak dapat dijalankan, seharusnya klo memang default maka formula
index pada bagian "array / refrance " saja yang terisi maka akan menghasilkan
nilai, tapi ini tidak.
mohon info lebih lanjut.
btw, sy bru 32 th, klo pak guru manggil bang, berarti usia pak guru kisaran 17
s.d 31 th...hebat jg di umur sekitaran segitu telah menjadi guru teladan,
bahkan sudah jadi wakil kepala sekolah...hehehe.... br,
odong nando
Pada Selasa, 1 Maret 2016 12:04, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Bang Odong.
di Helpnya excel ada kok (Excel > Function Reference)
misalnya untuk HLOOKUP tertulis syntaxnya:
HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
atau index:
INDEX(array,row_num,column_num)setahu saya yang tidak berhuruf tebal merupakan
default dan boleh untuk tidak diisi.
tapi kita tunggu pencerahan yang lebih OK.
2016-02-29 16:00 GMT+07:00 odong nando [email protected] [belajar-excel]
<[email protected]>:
dear all,
berdasarkan keterangan boz kid yang ada disini, saya ingin menanyakan, apakah
semua formula excel memiliki nilai default, bila memang ada, dimanakah saya
dapat mempelajarinya....?atau bila ada member / moderator bexcel yang berkenan
menjabarkan tentang formula excel yang memiliki default silahkan
dijabarkan...trimakasih... br,
odong nando
#yiv5796249912 #yiv5796249912 -- #yiv5796249912ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5796249912
#yiv5796249912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5796249912
#yiv5796249912ygrp-mkp #yiv5796249912hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5796249912 #yiv5796249912ygrp-mkp #yiv5796249912ads
{margin-bottom:10px;}#yiv5796249912 #yiv5796249912ygrp-mkp .yiv5796249912ad
{padding:0 0;}#yiv5796249912 #yiv5796249912ygrp-mkp .yiv5796249912ad p
{margin:0;}#yiv5796249912 #yiv5796249912ygrp-mkp .yiv5796249912ad a
{color:#0000ff;text-decoration:none;}#yiv5796249912 #yiv5796249912ygrp-sponsor
#yiv5796249912ygrp-lc {font-family:Arial;}#yiv5796249912
#yiv5796249912ygrp-sponsor #yiv5796249912ygrp-lc #yiv5796249912hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5796249912
#yiv5796249912ygrp-sponsor #yiv5796249912ygrp-lc .yiv5796249912ad
{margin-bottom:10px;padding:0 0;}#yiv5796249912 #yiv5796249912actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5796249912
#yiv5796249912activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5796249912
#yiv5796249912activity span {font-weight:700;}#yiv5796249912
#yiv5796249912activity span:first-child
{text-transform:uppercase;}#yiv5796249912 #yiv5796249912activity span a
{color:#5085b6;text-decoration:none;}#yiv5796249912 #yiv5796249912activity span
span {color:#ff7900;}#yiv5796249912 #yiv5796249912activity span
.yiv5796249912underline {text-decoration:underline;}#yiv5796249912
.yiv5796249912attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5796249912 .yiv5796249912attach div a
{text-decoration:none;}#yiv5796249912 .yiv5796249912attach img
{border:none;padding-right:5px;}#yiv5796249912 .yiv5796249912attach label
{display:block;margin-bottom:5px;}#yiv5796249912 .yiv5796249912attach label a
{text-decoration:none;}#yiv5796249912 blockquote {margin:0 0 0
4px;}#yiv5796249912 .yiv5796249912bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5796249912
.yiv5796249912bold a {text-decoration:none;}#yiv5796249912 dd.yiv5796249912last
p a {font-family:Verdana;font-weight:700;}#yiv5796249912 dd.yiv5796249912last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5796249912
dd.yiv5796249912last p span.yiv5796249912yshortcuts
{margin-right:0;}#yiv5796249912 div.yiv5796249912attach-table div div a
{text-decoration:none;}#yiv5796249912 div.yiv5796249912attach-table
{width:400px;}#yiv5796249912 div.yiv5796249912file-title a, #yiv5796249912
div.yiv5796249912file-title a:active, #yiv5796249912
div.yiv5796249912file-title a:hover, #yiv5796249912 div.yiv5796249912file-title
a:visited {text-decoration:none;}#yiv5796249912 div.yiv5796249912photo-title a,
#yiv5796249912 div.yiv5796249912photo-title a:active, #yiv5796249912
div.yiv5796249912photo-title a:hover, #yiv5796249912
div.yiv5796249912photo-title a:visited {text-decoration:none;}#yiv5796249912
div#yiv5796249912ygrp-mlmsg #yiv5796249912ygrp-msg p a
span.yiv5796249912yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5796249912
.yiv5796249912green {color:#628c2a;}#yiv5796249912 .yiv5796249912MsoNormal
{margin:0 0 0 0;}#yiv5796249912 o {font-size:0;}#yiv5796249912
#yiv5796249912photos div {float:left;width:72px;}#yiv5796249912
#yiv5796249912photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5796249912
#yiv5796249912photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5796249912
#yiv5796249912reco-category {font-size:77%;}#yiv5796249912
#yiv5796249912reco-desc {font-size:77%;}#yiv5796249912 .yiv5796249912replbq
{margin:4px;}#yiv5796249912 #yiv5796249912ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5796249912 #yiv5796249912ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5796249912
#yiv5796249912ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5796249912
#yiv5796249912ygrp-mlmsg select, #yiv5796249912 input, #yiv5796249912 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5796249912
#yiv5796249912ygrp-mlmsg pre, #yiv5796249912 code {font:115%
monospace;}#yiv5796249912 #yiv5796249912ygrp-mlmsg *
{line-height:1.22em;}#yiv5796249912 #yiv5796249912ygrp-mlmsg #yiv5796249912logo
{padding-bottom:10px;}#yiv5796249912 #yiv5796249912ygrp-msg p a
{font-family:Verdana;}#yiv5796249912 #yiv5796249912ygrp-msg
p#yiv5796249912attach-count span {color:#1E66AE;font-weight:700;}#yiv5796249912
#yiv5796249912ygrp-reco #yiv5796249912reco-head
{color:#ff7900;font-weight:700;}#yiv5796249912 #yiv5796249912ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5796249912 #yiv5796249912ygrp-sponsor
#yiv5796249912ov li a {font-size:130%;text-decoration:none;}#yiv5796249912
#yiv5796249912ygrp-sponsor #yiv5796249912ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5796249912
#yiv5796249912ygrp-sponsor #yiv5796249912ov ul {margin:0;padding:0 0 0
8px;}#yiv5796249912 #yiv5796249912ygrp-text
{font-family:Georgia;}#yiv5796249912 #yiv5796249912ygrp-text p {margin:0 0 1em
0;}#yiv5796249912 #yiv5796249912ygrp-text tt {font-size:120%;}#yiv5796249912
#yiv5796249912ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5796249912
