Yth. Mr. Kid
dari beberapa contoh yang Mr. Kid berikan pada balasan sebelumnya ..
Sel blank jika :- dikenai fungsi excel bertipe fungsi teks (misalnya, trim,
left, substitute dll) maka hasilnya tidak tampak (blank kosong)- dikenai fungsi
excel bertipe fungsi matematika (fungsi int,+), fungsi lookup reference (fungsi
vlookup, index) maka hasilnya tampak ( 0, 123, #N/A)
apakah demikian Mr. Kid ? mohon pencerahannya
Terima kasih
On Friday, June 9, 2017 9:45 PM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Hai BeExceller,
Pakai contoh yang lebih banyak ya, supaya mudah dalam menemukan benang merahnya.
Silakan dirembug bareng-bareng...
Moga-moga jadi bagian dari tafakur.
Regards,
Kid
On Fri, Jun 9, 2017 at 12:47 PM, Eira I Arie cheivory_bri...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Yth. Mr. Kid dan M. Ade
hmmmmm hehehehe .. terlihat kasat penglihatan saya semacam itu Mr. Kid
(hasilnya 0 sama tampak seperti blank). untuk tanda tanya yang pertama dan
ketiga, saya belum mudeng .. hehehehemohon kiranya berkenan memberi penjelasan
..
Terima kasih
On Friday, June 9, 2017 6:52 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com > wrote:
hehehe...
trus apa beda sebenarnya ? apa iya sekedar hasilnya 0 sama tampak seperti blank
?
kok bisa beda hasilnya ?
Regards,
Kid
On Thu, Jun 8, 2017 at 8:46 AM, Eira I Arie cheivory_bri...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com > wrote:
Yth. Mr. Kid
Formula pertama = menghasilkan 0Formula kedua = menghasilkan kosong " "
fungsi trim sepanjang saya tahu berguna untuk menghilangkan spasi yang
berlebih. tetapi sheet baru kan masih bersih yaa ..
setelah saya praktekkan arahan Mr. Kid dalam case ini sudah berhasil.
terima kasih Mr. Kid
On Thursday, June 8, 2017 5:29 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com > wrote:
Hai Eria,
Coba buat sheet baru. Seluruh cells dalam sheet baru pastilah masih kosong
beneran (blank).
di A1 tulis formula =B1 enter
di A2 tulis formula =Trim( B1 )
Apa beda dari kedua formula tersebut (kedua formula sama-sama merujuk ke cells
B1 bukan) ?
Regards,
Kid
On Wed, Jun 7, 2017 at 11:11 AM, Eira I Arie cheivory_bri...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com > wrote:
Yth > Pak Nang dan Mr. Kid terima kasih atas bantuannya ..
Mohon maaf tanya lagi masih terkait case tersebut ..
dalam case tersebut terdapat formula misalnya =IF(H40<>"";COUNTA($H$26:H40);
"") .. beberapa rujukan dari formula tersebut sebenarnya adalah kosong / tidak
ada isinya tetapi mengapa hasilnya ada ya ? yang akhirnya dalam case ini
menyebabkan baris (mestinya) kosong tidak terhidden... Mengapa ya kira2 bisa
seperti itu dan mohon solusinya ..
Terima kasih
On Wednesday, June 7, 2017 5:46 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com > wrote:
Wa'alaikumussalam wr wb
File terlampir.
Wassalamu'alaikum wr wb
Kid
2017-06-02 13:56 GMT+07:00 cheivory_bri...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com >:
Yth. Be-Exceler
Assalaamu'alaikum Wr Wb
Mohon bantuannya untuk case terlampir.
Terima Kasih
Wassalaamu'alaikum Wr Wb
Ari
#yiv8385536943 #yiv8385536943 -- #yiv8385536943ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8385536943
#yiv8385536943ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8385536943
#yiv8385536943ygrp-mkp #yiv8385536943hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8385536943 #yiv8385536943ygrp-mkp #yiv8385536943ads
{margin-bottom:10px;}#yiv8385536943 #yiv8385536943ygrp-mkp .yiv8385536943ad
{padding:0 0;}#yiv8385536943 #yiv8385536943ygrp-mkp .yiv8385536943ad p
{margin:0;}#yiv8385536943 #yiv8385536943ygrp-mkp .yiv8385536943ad a
{color:#0000ff;text-decoration:none;}#yiv8385536943 #yiv8385536943ygrp-sponsor
#yiv8385536943ygrp-lc {font-family:Arial;}#yiv8385536943
#yiv8385536943ygrp-sponsor #yiv8385536943ygrp-lc #yiv8385536943hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8385536943
#yiv8385536943ygrp-sponsor #yiv8385536943ygrp-lc .yiv8385536943ad
{margin-bottom:10px;padding:0 0;}#yiv8385536943 #yiv8385536943actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8385536943
#yiv8385536943activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8385536943
#yiv8385536943activity span {font-weight:700;}#yiv8385536943
#yiv8385536943activity span:first-child
{text-transform:uppercase;}#yiv8385536943 #yiv8385536943activity span a
{color:#5085b6;text-decoration:none;}#yiv8385536943 #yiv8385536943activity span
span {color:#ff7900;}#yiv8385536943 #yiv8385536943activity span
.yiv8385536943underline {text-decoration:underline;}#yiv8385536943
.yiv8385536943attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8385536943 .yiv8385536943attach div a
{text-decoration:none;}#yiv8385536943 .yiv8385536943attach img
{border:none;padding-right:5px;}#yiv8385536943 .yiv8385536943attach label
{display:block;margin-bottom:5px;}#yiv8385536943 .yiv8385536943attach label a
{text-decoration:none;}#yiv8385536943 blockquote {margin:0 0 0
4px;}#yiv8385536943 .yiv8385536943bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8385536943
.yiv8385536943bold a {text-decoration:none;}#yiv8385536943 dd.yiv8385536943last
p a {font-family:Verdana;font-weight:700;}#yiv8385536943 dd.yiv8385536943last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8385536943
dd.yiv8385536943last p span.yiv8385536943yshortcuts
{margin-right:0;}#yiv8385536943 div.yiv8385536943attach-table div div a
{text-decoration:none;}#yiv8385536943 div.yiv8385536943attach-table
{width:400px;}#yiv8385536943 div.yiv8385536943file-title a, #yiv8385536943
div.yiv8385536943file-title a:active, #yiv8385536943
div.yiv8385536943file-title a:hover, #yiv8385536943 div.yiv8385536943file-title
a:visited {text-decoration:none;}#yiv8385536943 div.yiv8385536943photo-title a,
#yiv8385536943 div.yiv8385536943photo-title a:active, #yiv8385536943
div.yiv8385536943photo-title a:hover, #yiv8385536943
div.yiv8385536943photo-title a:visited {text-decoration:none;}#yiv8385536943
div#yiv8385536943ygrp-mlmsg #yiv8385536943ygrp-msg p a
span.yiv8385536943yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8385536943
.yiv8385536943green {color:#628c2a;}#yiv8385536943 .yiv8385536943MsoNormal
{margin:0 0 0 0;}#yiv8385536943 o {font-size:0;}#yiv8385536943
#yiv8385536943photos div {float:left;width:72px;}#yiv8385536943
#yiv8385536943photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8385536943
#yiv8385536943photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8385536943
#yiv8385536943reco-category {font-size:77%;}#yiv8385536943
#yiv8385536943reco-desc {font-size:77%;}#yiv8385536943 .yiv8385536943replbq
{margin:4px;}#yiv8385536943 #yiv8385536943ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8385536943 #yiv8385536943ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8385536943
#yiv8385536943ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8385536943
#yiv8385536943ygrp-mlmsg select, #yiv8385536943 input, #yiv8385536943 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8385536943
#yiv8385536943ygrp-mlmsg pre, #yiv8385536943 code {font:115%
monospace;}#yiv8385536943 #yiv8385536943ygrp-mlmsg *
{line-height:1.22em;}#yiv8385536943 #yiv8385536943ygrp-mlmsg #yiv8385536943logo
{padding-bottom:10px;}#yiv8385536943 #yiv8385536943ygrp-msg p a
{font-family:Verdana;}#yiv8385536943 #yiv8385536943ygrp-msg
p#yiv8385536943attach-count span {color:#1E66AE;font-weight:700;}#yiv8385536943
#yiv8385536943ygrp-reco #yiv8385536943reco-head
{color:#ff7900;font-weight:700;}#yiv8385536943 #yiv8385536943ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8385536943 #yiv8385536943ygrp-sponsor
#yiv8385536943ov li a {font-size:130%;text-decoration:none;}#yiv8385536943
#yiv8385536943ygrp-sponsor #yiv8385536943ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8385536943
#yiv8385536943ygrp-sponsor #yiv8385536943ov ul {margin:0;padding:0 0 0
8px;}#yiv8385536943 #yiv8385536943ygrp-text
{font-family:Georgia;}#yiv8385536943 #yiv8385536943ygrp-text p {margin:0 0 1em
0;}#yiv8385536943 #yiv8385536943ygrp-text tt {font-size:120%;}#yiv8385536943
#yiv8385536943ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8385536943
