[belajar-excel] angka 0 muncul pada hasil RUMUS [1 Attachment]

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

[belajar-excel] angka 0 muncul pada hasil RUMUS [1 Attachment]

HAIRUL ALAM
SalamRekan-Rekan BeExcel
Selamat pagi
seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WRbagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL
Terimakasih Banyak
AssalamualaikumHairul Alam

=?UTF-8?b?YW5na2EgMCB0YW1waWwgcGFkYSBSVU1VUy54bHN4?= (32K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] angka 0 muncul pada hasil RUMUS

M.Ade Alfarid
Pada sheet WR hasil akhir bernilai 0 (nol) sedangkan pada sheet WP dan RL
hasil akhir nilainya kosong (empty).

Makanya pada sheet WP tampil /muncul angka bernilai 0 (nol).

Jika ingin sheet WP tidak tampil angka 0 (nol) ,format sel saja

Pilih custom, lalu tuliskan ;;”” (titik koma titik koma aphostrop dua
aphostrop dua)



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Monday, August 26, 2019 9:08 AM
*To:* [hidden email]
*Subject:* [belajar-excel] angka 0 muncul pada hasil RUMUS [1 Attachment]





Salam

Rekan-Rekan BeExcel



Selamat pagi



seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WR

bagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL



Terimakasih Banyak



Assalamualaikum

Hairul Alam



image001.jpg (492 bytes) Download Attachment
image002.jpg (454 bytes) Download Attachment
format sel angka 0 seolah-olah tidak tampil.png (41K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] angka 0 muncul pada hasil RUMUS

HAIRUL ALAM
 Terimakasi Mas M.Ade
Hairul Alam
    Pada Senin, 26 Agustus 2019 10.12.32 GMT+7, 'M.Ade Alfarid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  


Pada sheet WR hasil akhir bernilai 0 (nol) sedangkan pada sheet WP dan RL hasil akhir nilainya kosong (empty).

Makanya pada sheet WP tampil /muncul angka bernilai 0 (nol).

Jika ingin sheet WP tidak tampil angka 0 (nol) ,format sel saja

Pilih custom, lalu tuliskan ;;”” (titik koma titik koma aphostrop dua aphostrop dua)

 

From: belajar-excel@yahoogroups..com [mailto:[hidden email]]
Sent: Monday, August 26, 2019 9:08 AM
To: [hidden email]
Subject: [belajar-excel] angka 0 muncul pada hasil RUMUS [1 Attachment]

 

 

Salam

Rekan-Rekan BeExcel

 

Selamat pagi

 

seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WR

bagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL

 

Terimakasih Banyak

 

Assalamualaikum

Hairul Alam


  #yiv1039355259 #yiv1039355259 -- #yiv1039355259ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1039355259 #yiv1039355259ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1039355259 #yiv1039355259ygrp-mkp #yiv1039355259hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1039355259 #yiv1039355259ygrp-mkp #yiv1039355259ads {margin-bottom:10px;}#yiv1039355259 #yiv1039355259ygrp-mkp .yiv1039355259ad {padding:0 0;}#yiv1039355259 #yiv1039355259ygrp-mkp .yiv1039355259ad p {margin:0;}#yiv1039355259 #yiv1039355259ygrp-mkp .yiv1039355259ad a {color:#0000ff;text-decoration:none;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ygrp-lc {font-family:Arial;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ygrp-lc #yiv1039355259hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ygrp-lc .yiv1039355259ad {margin-bottom:10px;padding:0 0;}#yiv1039355259 #yiv1039355259actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1039355259 #yiv1039355259activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1039355259 #yiv1039355259activity span {font-weight:700;}#yiv1039355259 #yiv1039355259activity span:first-child {text-transform:uppercase;}#yiv1039355259 #yiv1039355259activity span a {color:#5085b6;text-decoration:none;}#yiv1039355259 #yiv1039355259activity span span {color:#ff7900;}#yiv1039355259 #yiv1039355259activity span .yiv1039355259underline {text-decoration:underline;}#yiv1039355259 .yiv1039355259attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1039355259 .yiv1039355259attach div a {text-decoration:none;}#yiv1039355259 .yiv1039355259attach img {border:none;padding-right:5px;}#yiv1039355259 .yiv1039355259attach label {display:block;margin-bottom:5px;}#yiv1039355259 .yiv1039355259attach label a {text-decoration:none;}#yiv1039355259 blockquote {margin:0 0 0 4px;}#yiv1039355259 .yiv1039355259bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1039355259 .yiv1039355259bold a {text-decoration:none;}#yiv1039355259 dd.yiv1039355259last p a {font-family:Verdana;font-weight:700;}#yiv1039355259 dd.yiv1039355259last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1039355259 dd.yiv1039355259last p span.yiv1039355259yshortcuts {margin-right:0;}#yiv1039355259 div.yiv1039355259attach-table div div a {text-decoration:none;}#yiv1039355259 div.yiv1039355259attach-table {width:400px;}#yiv1039355259 div.yiv1039355259file-title a, #yiv1039355259 div.yiv1039355259file-title a:active, #yiv1039355259 div.yiv1039355259file-title a:hover, #yiv1039355259 div.yiv1039355259file-title a:visited {text-decoration:none;}#yiv1039355259 div.yiv1039355259photo-title a, #yiv1039355259 div.yiv1039355259photo-title a:active, #yiv1039355259 div.yiv1039355259photo-title a:hover, #yiv1039355259 div.yiv1039355259photo-title a:visited {text-decoration:none;}#yiv1039355259 div#yiv1039355259ygrp-mlmsg #yiv1039355259ygrp-msg p a span.yiv1039355259yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1039355259 .yiv1039355259green {color:#628c2a;}#yiv1039355259 .yiv1039355259MsoNormal {margin:0 0 0 0;}#yiv1039355259 o {font-size:0;}#yiv1039355259 #yiv1039355259photos div {float:left;width:72px;}#yiv1039355259 #yiv1039355259photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1039355259 #yiv1039355259photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1039355259 #yiv1039355259reco-category {font-size:77%;}#yiv1039355259 #yiv1039355259reco-desc {font-size:77%;}#yiv1039355259 .yiv1039355259replbq {margin:4px;}#yiv1039355259 #yiv1039355259ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1039355259 #yiv1039355259ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1039355259 #yiv1039355259ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1039355259 #yiv1039355259ygrp-mlmsg select, #yiv1039355259 input, #yiv1039355259 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1039355259 #yiv1039355259ygrp-mlmsg pre, #yiv1039355259 code {font:115% monospace;}#yiv1039355259 #yiv1039355259ygrp-mlmsg * {line-height:1.22em;}#yiv1039355259 #yiv1039355259ygrp-mlmsg #yiv1039355259logo {padding-bottom:10px;}#yiv1039355259 #yiv1039355259ygrp-msg p a {font-family:Verdana;}#yiv1039355259 #yiv1039355259ygrp-msg p#yiv1039355259attach-count span {color:#1E66AE;font-weight:700;}#yiv1039355259 #yiv1039355259ygrp-reco #yiv1039355259reco-head {color:#ff7900;font-weight:700;}#yiv1039355259 #yiv1039355259ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ov li a {font-size:130%;text-decoration:none;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1039355259 #yiv1039355259ygrp-sponsor #yiv1039355259ov ul {margin:0;padding:0 0 0 8px;}#yiv1039355259 #yiv1039355259ygrp-text {font-family:Georgia;}#yiv1039355259 #yiv1039355259ygrp-text p {margin:0 0 1em 0;}#yiv1039355259 #yiv1039355259ygrp-text tt {font-size:120%;}#yiv1039355259 #yiv1039355259ygrp-vital ul li:last-child {border-right:none !important;}#yiv1039355259
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] angka 0 muncul pada hasil RUMUS

Eira_ariE
In reply to this post by HAIRUL ALAM

Pak Hairul Alam ..
Coba ubah pengaturan option excel bagian advanced display ..silakan uncheck pada isian ... zero value

terima kasih ..ari    On Monday, August 26, 2019, 09:40:03 AM GMT+7, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

SalamRekan-Rekan BeExcel
Selamat pagi
seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WRbagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL
Terimakasih Banyak
AssalamualaikumHairul Alam  #yiv1288444169 #yiv1288444169 -- #yiv1288444169ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1288444169 #yiv1288444169ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1288444169 #yiv1288444169ygrp-mkp #yiv1288444169hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1288444169 #yiv1288444169ygrp-mkp #yiv1288444169ads {margin-bottom:10px;}#yiv1288444169 #yiv1288444169ygrp-mkp .yiv1288444169ad {padding:0 0;}#yiv1288444169 #yiv1288444169ygrp-mkp .yiv1288444169ad p {margin:0;}#yiv1288444169 #yiv1288444169ygrp-mkp .yiv1288444169ad a {color:#0000ff;text-decoration:none;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ygrp-lc {font-family:Arial;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ygrp-lc #yiv1288444169hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ygrp-lc .yiv1288444169ad {margin-bottom:10px;padding:0 0;}#yiv1288444169 #yiv1288444169actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1288444169 #yiv1288444169activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1288444169 #yiv1288444169activity span {font-weight:700;}#yiv1288444169 #yiv1288444169activity span:first-child {text-transform:uppercase;}#yiv1288444169 #yiv1288444169activity span a {color:#5085b6;text-decoration:none;}#yiv1288444169 #yiv1288444169activity span span {color:#ff7900;}#yiv1288444169 #yiv1288444169activity span .yiv1288444169underline {text-decoration:underline;}#yiv1288444169 .yiv1288444169attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1288444169 .yiv1288444169attach div a {text-decoration:none;}#yiv1288444169 .yiv1288444169attach img {border:none;padding-right:5px;}#yiv1288444169 .yiv1288444169attach label {display:block;margin-bottom:5px;}#yiv1288444169 .yiv1288444169attach label a {text-decoration:none;}#yiv1288444169 blockquote {margin:0 0 0 4px;}#yiv1288444169 .yiv1288444169bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1288444169 .yiv1288444169bold a {text-decoration:none;}#yiv1288444169 dd.yiv1288444169last p a {font-family:Verdana;font-weight:700;}#yiv1288444169 dd.yiv1288444169last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1288444169 dd.yiv1288444169last p span.yiv1288444169yshortcuts {margin-right:0;}#yiv1288444169 div.yiv1288444169attach-table div div a {text-decoration:none;}#yiv1288444169 div.yiv1288444169attach-table {width:400px;}#yiv1288444169 div.yiv1288444169file-title a, #yiv1288444169 div.yiv1288444169file-title a:active, #yiv1288444169 div.yiv1288444169file-title a:hover, #yiv1288444169 div.yiv1288444169file-title a:visited {text-decoration:none;}#yiv1288444169 div.yiv1288444169photo-title a, #yiv1288444169 div.yiv1288444169photo-title a:active, #yiv1288444169 div.yiv1288444169photo-title a:hover, #yiv1288444169 div.yiv1288444169photo-title a:visited {text-decoration:none;}#yiv1288444169 div#yiv1288444169ygrp-mlmsg #yiv1288444169ygrp-msg p a span.yiv1288444169yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1288444169 .yiv1288444169green {color:#628c2a;}#yiv1288444169 .yiv1288444169MsoNormal {margin:0 0 0 0;}#yiv1288444169 o {font-size:0;}#yiv1288444169 #yiv1288444169photos div {float:left;width:72px;}#yiv1288444169 #yiv1288444169photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1288444169 #yiv1288444169photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1288444169 #yiv1288444169reco-category {font-size:77%;}#yiv1288444169 #yiv1288444169reco-desc {font-size:77%;}#yiv1288444169 .yiv1288444169replbq {margin:4px;}#yiv1288444169 #yiv1288444169ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1288444169 #yiv1288444169ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1288444169 #yiv1288444169ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1288444169 #yiv1288444169ygrp-mlmsg select, #yiv1288444169 input, #yiv1288444169 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1288444169 #yiv1288444169ygrp-mlmsg pre, #yiv1288444169 code {font:115% monospace;}#yiv1288444169 #yiv1288444169ygrp-mlmsg * {line-height:1.22em;}#yiv1288444169 #yiv1288444169ygrp-mlmsg #yiv1288444169logo {padding-bottom:10px;}#yiv1288444169 #yiv1288444169ygrp-msg p a {font-family:Verdana;}#yiv1288444169 #yiv1288444169ygrp-msg p#yiv1288444169attach-count span {color:#1E66AE;font-weight:700;}#yiv1288444169 #yiv1288444169ygrp-reco #yiv1288444169reco-head {color:#ff7900;font-weight:700;}#yiv1288444169 #yiv1288444169ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ov li a {font-size:130%;text-decoration:none;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1288444169 #yiv1288444169ygrp-sponsor #yiv1288444169ov ul {margin:0;padding:0 0 0 8px;}#yiv1288444169 #yiv1288444169ygrp-text {font-family:Georgia;}#yiv1288444169 #yiv1288444169ygrp-text p {margin:0 0 1em 0;}#yiv1288444169 #yiv1288444169ygrp-text tt {font-size:120%;}#yiv1288444169 #yiv1288444169ygrp-vital ul li:last-child {border-right:none !important;}#yiv1288444169
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] angka 0 muncul pada hasil RUMUS

HAIRUL ALAM
In reply to this post by HAIRUL ALAM
 Salam Mas M.Ade
kalau untuk option advance semua yang angka 0 pasti hilang
Terimakasih
    Pada Senin, 26 Agustus 2019 10.49.30 GMT+7, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:

  

 Terimakasi Mas M.Ade
Hairul Alam
    Pada Senin, 26 Agustus 2019 10.12.32 GMT+7, 'M.Ade Alfarid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  


Pada sheet WR hasil akhir bernilai 0 (nol) sedangkan pada sheet WP dan RL hasil akhir nilainya kosong (empty).

Makanya pada sheet WP tampil /muncul angka bernilai 0 (nol).

Jika ingin sheet WP tidak tampil angka 0 (nol) ,format sel saja

Pilih custom, lalu tuliskan ;;”” (titik koma titik koma aphostrop dua aphostrop dua)

 

From: belajar-excel@yahoogroups..com [mailto:[hidden email]]
Sent: Monday, August 26, 2019 9:08 AM
To: [hidden email]
Subject: [belajar-excel] angka 0 muncul pada hasil RUMUS [1 Attachment]

 

 

Salam

Rekan-Rekan BeExcel

 

Selamat pagi

 

seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WR

bagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL

 

Terimakasih Banyak

 

Assalamualaikum

Hairul Alam


      #yiv5996094517 #yiv5996094517 -- #yiv5996094517ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5996094517 #yiv5996094517ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5996094517 #yiv5996094517ygrp-mkp #yiv5996094517hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5996094517 #yiv5996094517ygrp-mkp #yiv5996094517ads {margin-bottom:10px;}#yiv5996094517 #yiv5996094517ygrp-mkp .yiv5996094517ad {padding:0 0;}#yiv5996094517 #yiv5996094517ygrp-mkp .yiv5996094517ad p {margin:0;}#yiv5996094517 #yiv5996094517ygrp-mkp .yiv5996094517ad a {color:#0000ff;text-decoration:none;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ygrp-lc {font-family:Arial;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ygrp-lc #yiv5996094517hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ygrp-lc .yiv5996094517ad {margin-bottom:10px;padding:0 0;}#yiv5996094517 #yiv5996094517actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5996094517 #yiv5996094517activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5996094517 #yiv5996094517activity span {font-weight:700;}#yiv5996094517 #yiv5996094517activity span:first-child {text-transform:uppercase;}#yiv5996094517 #yiv5996094517activity span a {color:#5085b6;text-decoration:none;}#yiv5996094517 #yiv5996094517activity span span {color:#ff7900;}#yiv5996094517 #yiv5996094517activity span .yiv5996094517underline {text-decoration:underline;}#yiv5996094517 .yiv5996094517attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5996094517 .yiv5996094517attach div a {text-decoration:none;}#yiv5996094517 .yiv5996094517attach img {border:none;padding-right:5px;}#yiv5996094517 .yiv5996094517attach label {display:block;margin-bottom:5px;}#yiv5996094517 .yiv5996094517attach label a {text-decoration:none;}#yiv5996094517 blockquote {margin:0 0 0 4px;}#yiv5996094517 .yiv5996094517bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5996094517 .yiv5996094517bold a {text-decoration:none;}#yiv5996094517 dd.yiv5996094517last p a {font-family:Verdana;font-weight:700;}#yiv5996094517 dd.yiv5996094517last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5996094517 dd.yiv5996094517last p span.yiv5996094517yshortcuts {margin-right:0;}#yiv5996094517 div.yiv5996094517attach-table div div a {text-decoration:none;}#yiv5996094517 div.yiv5996094517attach-table {width:400px;}#yiv5996094517 div.yiv5996094517file-title a, #yiv5996094517 div.yiv5996094517file-title a:active, #yiv5996094517 div...yiv5996094517file-title a:hover, #yiv5996094517 div.yiv5996094517file-title a:visited {text-decoration:none;}#yiv5996094517 div.yiv5996094517photo-title a, #yiv5996094517 div.yiv5996094517photo-title a:active, #yiv5996094517 div.yiv5996094517photo-title a:hover, #yiv5996094517 div.yiv5996094517photo-title a:visited {text-decoration:none;}#yiv5996094517 div#yiv5996094517ygrp-mlmsg #yiv5996094517ygrp-msg p a span.yiv5996094517yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5996094517 .yiv5996094517green {color:#628c2a;}#yiv5996094517 .yiv5996094517MsoNormal {margin:0 0 0 0;}#yiv5996094517 o {font-size:0;}#yiv5996094517 #yiv5996094517photos div {float:left;width:72px;}#yiv5996094517 #yiv5996094517photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5996094517 #yiv5996094517photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5996094517 #yiv5996094517reco-category {font-size:77%;}#yiv5996094517 #yiv5996094517reco-desc {font-size:77%;}#yiv5996094517 .yiv5996094517replbq {margin:4px;}#yiv5996094517 #yiv5996094517ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5996094517 #yiv5996094517ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5996094517 #yiv5996094517ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5996094517 #yiv5996094517ygrp-mlmsg select, #yiv5996094517 input, #yiv5996094517 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5996094517 #yiv5996094517ygrp-mlmsg pre, #yiv5996094517 code {font:115% monospace;}#yiv5996094517 #yiv5996094517ygrp-mlmsg * {line-height:1.22em;}#yiv5996094517 #yiv5996094517ygrp-mlmsg #yiv5996094517logo {padding-bottom:10px;}#yiv5996094517 #yiv5996094517ygrp-msg p a {font-family:Verdana;}#yiv5996094517 #yiv5996094517ygrp-msg p#yiv5996094517attach-count span {color:#1E66AE;font-weight:700;}#yiv5996094517 #yiv5996094517ygrp-reco #yiv5996094517reco-head {color:#ff7900;font-weight:700;}#yiv5996094517 #yiv5996094517ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ov li a {font-size:130%;text-decoration:none;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5996094517 #yiv5996094517ygrp-sponsor #yiv5996094517ov ul {margin:0;padding:0 0 0 8px;}#yiv5996094517 #yiv5996094517ygrp-text {font-family:Georgia;}#yiv5996094517 #yiv5996094517ygrp-text p {margin:0 0 1em 0;}#yiv5996094517 #yiv5996094517ygrp-text tt {font-size:120%;}#yiv5996094517 #yiv5996094517ygrp-vital ul li:last-child {border-right:none !important;}#yiv5996094517
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] angka 0 muncul pada hasil RUMUS

hendrik karnadi
In reply to this post by HAIRUL ALAM
 Dear Hairul Alam,Bisa diset dari pilihan Excel Options nya seperti di bawah ini:Pilih Advance, hilangkan centang pada Display options for this worksheet di kotak "Show a zero in cells that have zero value".
Salam,HK






    Pada Senin, 26 Agustus 2019 09.40.24 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

SalamRekan-Rekan BeExcel
Selamat pagi
seperti lampiran, dimana pada hasil rumus tampil angka 0 pada sheet WRbagaimana agar angka 0 tersebut tidak tampil seperti sheet WP dan RL
Terimakasih Banyak
AssalamualaikumHairul Alam    

1566793345447blob.jpg (69K) Download Attachment