mohon maaf seblumnya Mr. Kid.. Saya lupa compress gambarnya..Terima kasih
atas pencerahannya,
On Thursday, December 21, 2017, 1:17:58 PM GMT+8, 'Mr. Kid'
mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Hai Cindhi,
Dimohon, lain kali file lampiran diusahakan maksimal 250 KB ya....Sepertinya di
file lampiran Anda, ada image yang belum dikompresi. Andai akan menyertakan
image,
pastikan klik image yang sudah di-insert, menu Picture Tools -> ribbon Format
-> grup menu Adjust -> Compress Pictures -> pilih yang Email atau Web.
Sebaiknya disusun lebih dulu tabel referensi kriterianya. Dengan demikian, maka
tidak perlu pakai IF, tetapi bisa pakai LookUp.
Sila lihat disini tentang kasus seperti ini.
Regards,
Kid
2017-12-21 11:56 GMT+07:00 cindhi dwi cindhi.nou...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
Dear Master2,
Mohon pencerahannya, saya menggunakan 2 if bertingkat,Data pertama adalah data
tersebut termasuk pada kategori apa, setelah itu baru ditentukan apakah nilai
remark dari data tersebut.Saya sudah mencoba rumus if sesuai dengan pengetahuan
saya tapi kategori yg terdeteksi hanya kategori yg pertama kali disebutkan, dan
kategori lainnya dianggap FALSE..
File Terlampir
Mohon bantuannya, master2
#yiv0537127329 #yiv0537127329 -- #yiv0537127329ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0537127329
#yiv0537127329ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0537127329
#yiv0537127329ygrp-mkp #yiv0537127329hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0537127329 #yiv0537127329ygrp-mkp #yiv0537127329ads
{margin-bottom:10px;}#yiv0537127329 #yiv0537127329ygrp-mkp .yiv0537127329ad
{padding:0 0;}#yiv0537127329 #yiv0537127329ygrp-mkp .yiv0537127329ad p
{margin:0;}#yiv0537127329 #yiv0537127329ygrp-mkp .yiv0537127329ad a
{color:#0000ff;text-decoration:none;}#yiv0537127329 #yiv0537127329ygrp-sponsor
#yiv0537127329ygrp-lc {font-family:Arial;}#yiv0537127329
#yiv0537127329ygrp-sponsor #yiv0537127329ygrp-lc #yiv0537127329hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0537127329
#yiv0537127329ygrp-sponsor #yiv0537127329ygrp-lc ...yiv0537127329ad
{margin-bottom:10px;padding:0 0;}#yiv0537127329 #yiv0537127329actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0537127329
#yiv0537127329activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0537127329
#yiv0537127329activity span {font-weight:700;}#yiv0537127329
#yiv0537127329activity span:first-child
{text-transform:uppercase;}#yiv0537127329 #yiv0537127329activity span a
{color:#5085b6;text-decoration:none;}#yiv0537127329 #yiv0537127329activity span
span {color:#ff7900;}#yiv0537127329 #yiv0537127329activity span
.yiv0537127329underline {text-decoration:underline;}#yiv0537127329
.yiv0537127329attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0537127329 .yiv0537127329attach div a
{text-decoration:none;}#yiv0537127329 .yiv0537127329attach img
{border:none;padding-right:5px;}#yiv0537127329 .yiv0537127329attach label
{display:block;margin-bottom:5px;}#yiv0537127329 .yiv0537127329attach label a
{text-decoration:none;}#yiv0537127329 blockquote {margin:0 0 0
4px;}#yiv0537127329 .yiv0537127329bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0537127329
.yiv0537127329bold a {text-decoration:none;}#yiv0537127329 dd.yiv0537127329last
p a {font-family:Verdana;font-weight:700;}#yiv0537127329 dd.yiv0537127329last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0537127329
dd.yiv0537127329last p span.yiv0537127329yshortcuts
{margin-right:0;}#yiv0537127329 div.yiv0537127329attach-table div div a
{text-decoration:none;}#yiv0537127329 div.yiv0537127329attach-table
{width:400px;}#yiv0537127329 div.yiv0537127329file-title a, #yiv0537127329
div.yiv0537127329file-title a:active, #yiv0537127329
div.yiv0537127329file-title a:hover, #yiv0537127329 div.yiv0537127329file-title
a:visited {text-decoration:none;}#yiv0537127329 div.yiv0537127329photo-title a,
#yiv0537127329 div.yiv0537127329photo-title a:active, #yiv0537127329
div.yiv0537127329photo-title a:hover, #yiv0537127329
div.yiv0537127329photo-title a:visited {text-decoration:none;}#yiv0537127329
div#yiv0537127329ygrp-mlmsg #yiv0537127329ygrp-msg p a
span.yiv0537127329yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0537127329
.yiv0537127329green {color:#628c2a;}#yiv0537127329 .yiv0537127329MsoNormal
{margin:0 0 0 0;}#yiv0537127329 o {font-size:0;}#yiv0537127329
#yiv0537127329photos div {float:left;width:72px;}#yiv0537127329
#yiv0537127329photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0537127329
#yiv0537127329photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0537127329
#yiv0537127329reco-category {font-size:77%;}#yiv0537127329
#yiv0537127329reco-desc {font-size:77%;}#yiv0537127329 .yiv0537127329replbq
{margin:4px;}#yiv0537127329 #yiv0537127329ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0537127329 #yiv0537127329ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0537127329
#yiv0537127329ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0537127329
#yiv0537127329ygrp-mlmsg select, #yiv0537127329 input, #yiv0537127329 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0537127329
#yiv0537127329ygrp-mlmsg pre, #yiv0537127329 code {font:115%
monospace;}#yiv0537127329 #yiv0537127329ygrp-mlmsg *
{line-height:1.22em;}#yiv0537127329 #yiv0537127329ygrp-mlmsg #yiv0537127329logo
{padding-bottom:10px;}#yiv0537127329 #yiv0537127329ygrp-msg p a
{font-family:Verdana;}#yiv0537127329 #yiv0537127329ygrp-msg
p#yiv0537127329attach-count span {color:#1E66AE;font-weight:700;}#yiv0537127329
#yiv0537127329ygrp-reco #yiv0537127329reco-head
{color:#ff7900;font-weight:700;}#yiv0537127329 #yiv0537127329ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0537127329 #yiv0537127329ygrp-sponsor
#yiv0537127329ov li a {font-size:130%;text-decoration:none;}#yiv0537127329
#yiv0537127329ygrp-sponsor #yiv0537127329ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0537127329
#yiv0537127329ygrp-sponsor #yiv0537127329ov ul {margin:0;padding:0 0 0
8px;}#yiv0537127329 #yiv0537127329ygrp-text
{font-family:Georgia;}#yiv0537127329 #yiv0537127329ygrp-text p {margin:0 0 1em
0;}#yiv0537127329 #yiv0537127329ygrp-text tt {font-size:120%;}#yiv0537127329
#yiv0537127329ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0537127329
