[belajar-excel] sembunyikan formula [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] sembunyikan formula [1 Attachment]

Milis Belajar Excel mailing list
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
​bagaimana cara menyembuyikan formula berikut lampirannya
terima kasih​

 وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

MADE DAGANG.xlsx (19K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] sembunyikan formula

Milis Belajar Excel mailing list
Hai Syaiful,Coba tambahkan IFERROR, maka Function (predetermined formula) nya menjadi :=Iferror(formulanya,"").
Salam,HK

      From: "Syaiful Hanan [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 Sent: Tuesday, 23 May 2017, 9:12
 Subject: [belajar-excel] sembunyikan formula [1 Attachment]
   
   
السَّلَامُعَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ​bagaimana cara menyembuyikan formula berikut lampirannyaterima kasih​
 وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ 

  #yiv7931262703 #yiv7931262703 -- #yiv7931262703ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7931262703 #yiv7931262703ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7931262703 #yiv7931262703ygrp-mkp #yiv7931262703hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7931262703 #yiv7931262703ygrp-mkp #yiv7931262703ads {margin-bottom:10px;}#yiv7931262703 #yiv7931262703ygrp-mkp .yiv7931262703ad {padding:0 0;}#yiv7931262703 #yiv7931262703ygrp-mkp .yiv7931262703ad p {margin:0;}#yiv7931262703 #yiv7931262703ygrp-mkp .yiv7931262703ad a {color:#0000ff;text-decoration:none;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ygrp-lc {font-family:Arial;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ygrp-lc #yiv7931262703hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ygrp-lc .yiv7931262703ad {margin-bottom:10px;padding:0 0;}#yiv7931262703 #yiv7931262703actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7931262703 #yiv7931262703activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7931262703 #yiv7931262703activity span {font-weight:700;}#yiv7931262703 #yiv7931262703activity span:first-child {text-transform:uppercase;}#yiv7931262703 #yiv7931262703activity span a {color:#5085b6;text-decoration:none;}#yiv7931262703 #yiv7931262703activity span span {color:#ff7900;}#yiv7931262703 #yiv7931262703activity span .yiv7931262703underline {text-decoration:underline;}#yiv7931262703 .yiv7931262703attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7931262703 .yiv7931262703attach div a {text-decoration:none;}#yiv7931262703 .yiv7931262703attach img {border:none;padding-right:5px;}#yiv7931262703 .yiv7931262703attach label {display:block;margin-bottom:5px;}#yiv7931262703 .yiv7931262703attach label a {text-decoration:none;}#yiv7931262703 blockquote {margin:0 0 0 4px;}#yiv7931262703 .yiv7931262703bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7931262703 .yiv7931262703bold a {text-decoration:none;}#yiv7931262703 dd.yiv7931262703last p a {font-family:Verdana;font-weight:700;}#yiv7931262703 dd.yiv7931262703last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7931262703 dd.yiv7931262703last p span.yiv7931262703yshortcuts {margin-right:0;}#yiv7931262703 div.yiv7931262703attach-table div div a {text-decoration:none;}#yiv7931262703 div.yiv7931262703attach-table {width:400px;}#yiv7931262703 div.yiv7931262703file-title a, #yiv7931262703 div.yiv7931262703file-title a:active, #yiv7931262703 div.yiv7931262703file-title a:hover, #yiv7931262703 div.yiv7931262703file-title a:visited {text-decoration:none;}#yiv7931262703 div.yiv7931262703photo-title a, #yiv7931262703 div.yiv7931262703photo-title a:active, #yiv7931262703 div.yiv7931262703photo-title a:hover, #yiv7931262703 div.yiv7931262703photo-title a:visited {text-decoration:none;}#yiv7931262703 div#yiv7931262703ygrp-mlmsg #yiv7931262703ygrp-msg p a span.yiv7931262703yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7931262703 .yiv7931262703green {color:#628c2a;}#yiv7931262703 .yiv7931262703MsoNormal {margin:0 0 0 0;}#yiv7931262703 o {font-size:0;}#yiv7931262703 #yiv7931262703photos div {float:left;width:72px;}#yiv7931262703 #yiv7931262703photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7931262703 #yiv7931262703photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7931262703 #yiv7931262703reco-category {font-size:77%;}#yiv7931262703 #yiv7931262703reco-desc {font-size:77%;}#yiv7931262703 .yiv7931262703replbq {margin:4px;}#yiv7931262703 #yiv7931262703ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7931262703 #yiv7931262703ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7931262703 #yiv7931262703ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7931262703 #yiv7931262703ygrp-mlmsg select, #yiv7931262703 input, #yiv7931262703 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7931262703 #yiv7931262703ygrp-mlmsg pre, #yiv7931262703 code {font:115% monospace;}#yiv7931262703 #yiv7931262703ygrp-mlmsg * {line-height:1.22em;}#yiv7931262703 #yiv7931262703ygrp-mlmsg #yiv7931262703logo {padding-bottom:10px;}#yiv7931262703 #yiv7931262703ygrp-msg p a {font-family:Verdana;}#yiv7931262703 #yiv7931262703ygrp-msg p#yiv7931262703attach-count span {color:#1E66AE;font-weight:700;}#yiv7931262703 #yiv7931262703ygrp-reco #yiv7931262703reco-head {color:#ff7900;font-weight:700;}#yiv7931262703 #yiv7931262703ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ov li a {font-size:130%;text-decoration:none;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7931262703 #yiv7931262703ygrp-sponsor #yiv7931262703ov ul {margin:0;padding:0 0 0 8px;}#yiv7931262703 #yiv7931262703ygrp-text {font-family:Georgia;}#yiv7931262703 #yiv7931262703ygrp-text p {margin:0 0 1em 0;}#yiv7931262703 #yiv7931262703ygrp-text tt {font-size:120%;}#yiv7931262703 #yiv7931262703ygrp-vital ul li:last-child {border-right:none !important;}#yiv7931262703

   
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] sembunyikan formula

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Wa'alaikumussalam wr wb

Hai Syaiful,

Andai yang dimaksudkan oleh frase 'menyembuyikan formula' adalah :
1. tidak menampakkan di-formula bar (di formula bar tidak tampak bunyi
formula =blabla atau nilai dalam cells)
    langkahnya :
    a. unprotect sheet (jika sheet dalam keadaan terprotect)
    b. blok cells yang akan disembunyikan bunyi formulanya -> klik kanan
area yang terblok -> pilih Format Cells -> klik tab Protection -> centang
opsi Hidden -> OK
    c. protect worksheet (HARUS diprotect)
    d. save workbook

2. formula tidak menampakkan hasil error value seprti #ref, #na, #value, dsb
    langkahnya :
    a. unprotect sheet (jika sheet dalam keadaan terprotect)
    b. pada setiap cells berformula -> ubah bunyi formula dengan
menambahkan fungsi IFError, dengan susunan seperti ini :
            > bunyi formula asli yang ada di cells tersebut :
=bunyi_formula_aslinya
            > ubah menjadi :
                      -> xl2007 ke atas (direkomendasikan) :
  =*IFError(*  bunyi_formula_aslinya *, "" )*
                      -> versi apa saja (khusunya xl2003 ke bawah) :     =*IF(
IsError(* bunyi_formula_aslinya *) , "" ,* bunyi_formula_aslinya *)*
    c. lakukan pada bunyi formula lainnya
    d. protect sheet [bila perlu]
    e. save workbook

Wassalamu'alaikum wr wb
Kid



2017-05-23 9:10 GMT+07:00 Syaiful Hanan [hidden email]
[belajar-excel] <[hidden email]>:

>
>
>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> ​bagaimana cara menyembuyikan formula berikut lampirannya
> terima kasih​
>
>  وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] sembunyikan formula

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Assalamualaikum Syaiful.

Coba klik kanan, Format Cells, Tab Numbers, Pilih Custom, masukan *;;;*

Maaf kl belum sesuai ya ?

Wassalam.

*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

2017-05-23 9:10 GMT+07:00 Syaiful Hanan [hidden email]
[belajar-excel] <[hidden email]>:

>
>
>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> ​bagaimana cara menyembuyikan formula berikut lampirannya
> terima kasih​
>
>  وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
>
>
>
>