[belajar-excel] Digest Number 3999

Milis Belajar Microsoft Excel Group

3 Messages

Digest #3999

1a

Re: FORMULA JIKA [1 Attachment] by "Heri Pamungkas ( Gmail )" dchoosen88

2a

Bls: [belajar-excel] FORMULA JIKA [1 Attachment] by "HAIRUL ALAM"

3

Ganti logo dengan button sesuai dengan ukuran sell tertentu by "farud oke"

Messages

1a

Re: FORMULA JIKA [1 Attachment]

Sat Oct 22, 2016 5:27 am (PDT) . Posted by:

"Heri Pamungkas ( Gmail )" dchoosen88

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

Mohon maaf kalau saya salah menafsirkan.

Kalau yang saya tangkap, Mas Hairul mau agar bila
sama plek (opo bahasa Indonesiane) muncul "Benar" bila tidak sama
maka di kosongkan.

Begitukah ?!

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

Warm Regards,

On 22/10/2016 6:53, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] wrote:
> Assalamualaikum
> Para Master
>
> Sedikit masalah tentang formula JIKA
>
> Saya terkendala dengan masalah formula JIKA yang karakternya tidak
> sama seperti data terlampir
>
> Mohon Pencerahannya
>
> Terimakasih
>
> Wassalamualaikum
> Hairul Alam
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Bls: [belajar-excel] FORMULA JIKA [1 Attachment]

Sun Oct 23, 2016 12:51 am (PDT) . Posted by:

"HAIRUL ALAM"

AssalamualaikumPara master
Adakah rumus yang lain dan lebi sederhana untuk penggunaan IF seperti lampiran
Terimakasih
Wassalamualaikum

Pada Sabtu, 22 Oktober 2016 14:46, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  AssalamualaikumPara Master
Sedikit masalah tentang formula JIKA
Saya terkendala dengan masalah formula JIKA yang karakternya tidak sama seperti data terlampir
Mohon Pencerahannya
Terimakasih
WassalamualaikumHairul Alam #yiv2652746153 #yiv2652746153 -- #yiv2652746153ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2652746153 #yiv2652746153ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2652746153 #yiv2652746153ygrp-mkp #yiv2652746153hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2652746153 #yiv2652746153ygrp-mkp #yiv2652746153ads {margin-bottom:10px;}#yiv2652746153 #yiv2652746153ygrp-mkp .yiv2652746153ad {padding:0 0;}#yiv2652746153 #yiv2652746153ygrp-mkp .yiv2652746153ad p {margin:0;}#yiv2652746153 #yiv2652746153ygrp-mkp .yiv2652746153ad a {color:#0000ff;text-decoration:none;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ygrp-lc {font-family:Arial;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ygrp-lc #yiv2652746153hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ygrp-lc .yiv2652746153ad {margin-bottom:10px;padding:0 0;}#yiv2652746153 #yiv2652746153actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2652746153 #yiv2652746153activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2652746153 #yiv2652746153activity span {font-weight:700;}#yiv2652746153 #yiv2652746153activity span:first-child {text-transform:uppercase;}#yiv2652746153 #yiv2652746153activity span a {color:#5085b6;text-decoration:none;}#yiv2652746153 #yiv2652746153activity span span {color:#ff7900;}#yiv2652746153 #yiv2652746153activity span .yiv2652746153underline {text-decoration:underline;}#yiv2652746153 .yiv2652746153attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2652746153 .yiv2652746153attach div a {text-decoration:none;}#yiv2652746153 .yiv2652746153attach img {border:none;padding-right:5px;}#yiv2652746153 .yiv2652746153attach label {display:block;margin-bottom:5px;}#yiv2652746153 .yiv2652746153attach label a {text-decoration:none;}#yiv2652746153 blockquote {margin:0 0 0 4px;}#yiv2652746153 .yiv2652746153bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2652746153 .yiv2652746153bold a {text-decoration:none;}#yiv2652746153 dd.yiv2652746153last p a {font-family:Verdana;font-weight:700;}#yiv2652746153 dd.yiv2652746153last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2652746153 dd.yiv2652746153last p span.yiv2652746153yshortcuts {margin-right:0;}#yiv2652746153 div.yiv2652746153attach-table div div a {text-decoration:none;}#yiv2652746153 div.yiv2652746153attach-table {width:400px;}#yiv2652746153 div.yiv2652746153file-title a, #yiv2652746153 div.yiv2652746153file-title a:active, #yiv2652746153 div.yiv2652746153file-title a:hover, #yiv2652746153 div.yiv2652746153file-title a:visited {text-decoration:none;}#yiv2652746153 div.yiv2652746153photo-title a, #yiv2652746153 div.yiv2652746153photo-title a:active, #yiv2652746153 div.yiv2652746153photo-title a:hover, #yiv2652746153 div.yiv2652746153photo-title a:visited {text-decoration:none;}#yiv2652746153 div#yiv2652746153ygrp-mlmsg #yiv2652746153ygrp-msg p a span.yiv2652746153yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2652746153 .yiv2652746153green {color:#628c2a;}#yiv2652746153 .yiv2652746153MsoNormal {margin:0 0 0 0;}#yiv2652746153 o {font-size:0;}#yiv2652746153 #yiv2652746153photos div {float:left;width:72px;}#yiv2652746153 #yiv2652746153photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2652746153 #yiv2652746153photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2652746153 #yiv2652746153reco-category {font-size:77%;}#yiv2652746153 #yiv2652746153reco-desc {font-size:77%;}#yiv2652746153 .yiv2652746153replbq {margin:4px;}#yiv2652746153 #yiv2652746153ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2652746153 #yiv2652746153ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2652746153 #yiv2652746153ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2652746153 #yiv2652746153ygrp-mlmsg select, #yiv2652746153 input, #yiv2652746153 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2652746153 #yiv2652746153ygrp-mlmsg pre, #yiv2652746153 code {font:115% monospace;}#yiv2652746153 #yiv2652746153ygrp-mlmsg * {line-height:1.22em;}#yiv2652746153 #yiv2652746153ygrp-mlmsg #yiv2652746153logo {padding-bottom:10px;}#yiv2652746153 #yiv2652746153ygrp-msg p a {font-family:Verdana;}#yiv2652746153 #yiv2652746153ygrp-msg p#yiv2652746153attach-count span {color:#1E66AE;font-weight:700;}#yiv2652746153 #yiv2652746153ygrp-reco #yiv2652746153reco-head {color:#ff7900;font-weight:700;}#yiv2652746153 #yiv2652746153ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ov li a {font-size:130%;text-decoration:none;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2652746153 #yiv2652746153ygrp-sponsor #yiv2652746153ov ul {margin:0;padding:0 0 0 8px;}#yiv2652746153 #yiv2652746153ygrp-text {font-family:Georgia;}#yiv2652746153 #yiv2652746153ygrp-text p {margin:0 0 1em 0;}#yiv2652746153 #yiv2652746153ygrp-text tt {font-size:120%;}#yiv2652746153 #yiv2652746153ygrp-vital ul li:last-child {border-right:none !important;}#yiv2652746153

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3

Ganti logo dengan button sesuai dengan ukuran sell tertentu

Sun Oct 23, 2016 1:25 am (PDT) . Posted by:

"farud oke"

Assalamualaikum
mohon bantuan para master sekalian
saya sudah googling cara ganti logo dengan button dan sudah saya coba,tapi
yang jadi masalah gambarnya tidak sesuai dengan ukuran sell yang di
inginkan.
untuk lebih jelasnya saya lampirkan filenya
atas bantuannya saya ucapkan banyak2 terimakasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use