Sabtu, 27 Desember 2014

]] XL-mania [[ Digest Number 2783

14 Messages

Digest #2783
2b
Re: Multiple kriteria [1 Attachment] by "primas adexa" retroductionz
2c
Re: Multiple kriteria [1 Attachment] by "hendrik karnadi" hendrikkarnadi
2d
Re: Multiple kriteria [1 Attachment] by "Inv-WDC-Reconsile, ID3P-Linfox"
2e
Re: Multiple kriteria [1 Attachment] by "HERIS PAMUNTJAR" heris2001
5a
7a
Re: Mencari Sumber Total [1 Attachment] by "HERIS PAMUNTJAR" heris2001
8a
Bls: ]] XL-mania [[ membulatkan keatas dan kebawah [1 Attachment] by "Ilyas Kurniawan" ilyas.kurniawan@rocketmail.com
9a
Re: membulatkan keatas dan kebawah by ilyas.kurniawan@rocketmail.com

Messages

Fri Dec 26, 2014 5:40 am (PST) . Posted by:

"Eko Ludiono" waneko989@ymail.com

Sebelumnya terimakasih pak ahmad, sedikit lagi, kalau data yang sudah jadi terus formula saya pindahkan ke cell di bawah atau ke sheet yang laen hasilnya kosong blank ya pak, mohon pencerahanya,
Thx,
EKO


Pada Selasa, 23 Desember 2014 13:49, Ahmad Mubarok <amd.mubarok@gmail.com> menulis:


coba ini mas eko


On 15/12/2014 18:07, Eko Ludiono waneko989@ymail.com [XL-mania] wrote:

  Dear Temans,
Mohon bantuanya para suhu suhu excel,

Thx,


  #yiv6126383244 #yiv6126383244 -- #yiv6126383244ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6126383244 #yiv6126383244ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6126383244 #yiv6126383244ygrp-mkp #yiv6126383244hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6126383244 #yiv6126383244ygrp-mkp #yiv6126383244ads {margin-bottom:10px;}#yiv6126383244 #yiv6126383244ygrp-mkp .yiv6126383244ad {padding:0 0;}#yiv6126383244 #yiv6126383244ygrp-mkp .yiv6126383244ad p {margin:0;}#yiv6126383244 #yiv6126383244ygrp-mkp .yiv6126383244ad a {color:#0000ff;text-decoration:none;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ygrp-lc {font-family:Arial;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ygrp-lc #yiv6126383244hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ygrp-lc .yiv6126383244ad {margin-bottom:10px;padding:0 0;}#yiv6126383244 #yiv6126383244actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6126383244 #yiv6126383244activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6126383244 #yiv6126383244activity span {font-weight:700;}#yiv6126383244 #yiv6126383244activity span:first-child {text-transform:uppercase;}#yiv6126383244 #yiv6126383244activity span a {color:#5085b6;text-decoration:none;}#yiv6126383244 #yiv6126383244activity span span {color:#ff7900;}#yiv6126383244 #yiv6126383244activity span .yiv6126383244underline {text-decoration:underline;}#yiv6126383244 .yiv6126383244attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6126383244 .yiv6126383244attach div a {text-decoration:none;}#yiv6126383244 .yiv6126383244attach img {border:none;padding-right:5px;}#yiv6126383244 .yiv6126383244attach label {display:block;margin-bottom:5px;}#yiv6126383244 .yiv6126383244attach label a {text-decoration:none;}#yiv6126383244 blockquote {margin:0 0 0 4px;}#yiv6126383244 .yiv6126383244bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6126383244 .yiv6126383244bold a {text-decoration:none;}#yiv6126383244 dd.yiv6126383244last p a {font-family:Verdana;font-weight:700;}#yiv6126383244 dd.yiv6126383244last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6126383244 dd.yiv6126383244last p span.yiv6126383244yshortcuts {margin-right:0;}#yiv6126383244 div.yiv6126383244attach-table div div a {text-decoration:none;}#yiv6126383244 div.yiv6126383244attach-table {width:400px;}#yiv6126383244 div.yiv6126383244file-title a, #yiv6126383244 div.yiv6126383244file-title a:active, #yiv6126383244 div.yiv6126383244file-title a:hover, #yiv6126383244 div.yiv6126383244file-title a:visited {text-decoration:none;}#yiv6126383244 div.yiv6126383244photo-title a, #yiv6126383244 div.yiv6126383244photo-title a:active, #yiv6126383244 div.yiv6126383244photo-title a:hover, #yiv6126383244 div.yiv6126383244photo-title a:visited {text-decoration:none;}#yiv6126383244 div#yiv6126383244ygrp-mlmsg #yiv6126383244ygrp-msg p a span.yiv6126383244yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6126383244 .yiv6126383244green {color:#628c2a;}#yiv6126383244 .yiv6126383244MsoNormal {margin:0 0 0 0;}#yiv6126383244 o {font-size:0;}#yiv6126383244 #yiv6126383244photos div {float:left;width:72px;}#yiv6126383244 #yiv6126383244photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6126383244 #yiv6126383244photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6126383244 #yiv6126383244reco-category {font-size:77%;}#yiv6126383244 #yiv6126383244reco-desc {font-size:77%;}#yiv6126383244 .yiv6126383244replbq {margin:4px;}#yiv6126383244 #yiv6126383244ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6126383244 #yiv6126383244ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6126383244 #yiv6126383244ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6126383244 #yiv6126383244ygrp-mlmsg select, #yiv6126383244 input, #yiv6126383244 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6126383244 #yiv6126383244ygrp-mlmsg pre, #yiv6126383244 code {font:115% monospace;}#yiv6126383244 #yiv6126383244ygrp-mlmsg * {line-height:1.22em;}#yiv6126383244 #yiv6126383244ygrp-mlmsg #yiv6126383244logo {padding-bottom:10px;}#yiv6126383244 #yiv6126383244ygrp-msg p a {font-family:Verdana;}#yiv6126383244 #yiv6126383244ygrp-msg p#yiv6126383244attach-count span {color:#1E66AE;font-weight:700;}#yiv6126383244 #yiv6126383244ygrp-reco #yiv6126383244reco-head {color:#ff7900;font-weight:700;}#yiv6126383244 #yiv6126383244ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ov li a {font-size:130%;text-decoration:none;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6126383244 #yiv6126383244ygrp-sponsor #yiv6126383244ov ul {margin:0;padding:0 0 0 8px;}#yiv6126383244 #yiv6126383244ygrp-text {font-family:Georgia;}#yiv6126383244 #yiv6126383244ygrp-text p {margin:0 0 1em 0;}#yiv6126383244 #yiv6126383244ygrp-text tt {font-size:120%;}#yiv6126383244 #yiv6126383244ygrp-vital ul li:last-child {border-right:none !important;}#yiv6126383244



Fri Dec 26, 2014 5:40 am (PST) . Posted by:

"k_made"

Dear Agus; semoga membantu

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Monday, December 22, 2014 11:07 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Multiple kriteria [1 Attachment]


Dear pakar excel,

Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.

Terima kasih atas bantuannya.

Rgds,

Agus



Fri Dec 26, 2014 5:41 am (PST) . Posted by:

"primas adexa" retroductionz

Dear Pak Agus,
Berikut saya coba bantu dgn fungsi IF & And dgn sedikit perubahan asumsi point ke-2 & ke-3 yg diberi highlights kuning sbb :
jika B = 15, C <80% maka D = (C/80%*35)jika B < 15, C = berapa pun nilainya, maka D = 0

=IF(B3<15;0;IF(AND(B3=15;C3>=80%);35;IF(AND(B3=15;C3<80%);(C3/80%)*35;"??")))*file solusi terlampir
Semoga bermanfaat & sesuai harapan. Best regards,
Primas Adexa


From: "Agus Suyanto agus.suyanto@hino.co.id [XL-mania]" <XL-mania@yahoogroups.com>
To: XL-mania@yahoogroups.com
Sent: Monday, December 22, 2014 11:06 AM
Subject: ]] XL-mania [[ Multiple kriteria [1 Attachment]

  Dear pakar excel,   Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.   Terima kasih atas bantuannya.   Rgds,   Agus     #yiv7923565234 -- #yiv7923565234ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7923565234 #yiv7923565234ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7923565234 #yiv7923565234ygrp-mkp #yiv7923565234hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7923565234 #yiv7923565234ygrp-mkp #yiv7923565234ads {margin-bottom:10px;}#yiv7923565234 #yiv7923565234ygrp-mkp .yiv7923565234ad {padding:0 0;}#yiv7923565234 #yiv7923565234ygrp-mkp .yiv7923565234ad p {margin:0;}#yiv7923565234 #yiv7923565234ygrp-mkp .yiv7923565234ad a {color:#0000ff;text-decoration:none;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ygrp-lc {font-family:Arial;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ygrp-lc #yiv7923565234hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ygrp-lc .yiv7923565234ad {margin-bottom:10px;padding:0 0;}#yiv7923565234 #yiv7923565234actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7923565234 #yiv7923565234activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7923565234 #yiv7923565234activity span {font-weight:700;}#yiv7923565234 #yiv7923565234activity span:first-child {text-transform:uppercase;}#yiv7923565234 #yiv7923565234activity span a {color:#5085b6;text-decoration:none;}#yiv7923565234 #yiv7923565234activity span span {color:#ff7900;}#yiv7923565234 #yiv7923565234activity span .yiv7923565234underline {text-decoration:underline;}#yiv7923565234 .yiv7923565234attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7923565234 .yiv7923565234attach div a {text-decoration:none;}#yiv7923565234 .yiv7923565234attach img {border:none;padding-right:5px;}#yiv7923565234 .yiv7923565234attach label {display:block;margin-bottom:5px;}#yiv7923565234 .yiv7923565234attach label a {text-decoration:none;}#yiv7923565234 blockquote {margin:0 0 0 4px;}#yiv7923565234 .yiv7923565234bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7923565234 .yiv7923565234bold a {text-decoration:none;}#yiv7923565234 dd.yiv7923565234last p a {font-family:Verdana;font-weight:700;}#yiv7923565234 dd.yiv7923565234last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7923565234 dd.yiv7923565234last p span.yiv7923565234yshortcuts {margin-right:0;}#yiv7923565234 div.yiv7923565234attach-table div div a {text-decoration:none;}#yiv7923565234 div.yiv7923565234attach-table {width:400px;}#yiv7923565234 div.yiv7923565234file-title a, #yiv7923565234 div.yiv7923565234file-title a:active, #yiv7923565234 div.yiv7923565234file-title a:hover, #yiv7923565234 div.yiv7923565234file-title a:visited {text-decoration:none;}#yiv7923565234 div.yiv7923565234photo-title a, #yiv7923565234 div.yiv7923565234photo-title a:active, #yiv7923565234 div.yiv7923565234photo-title a:hover, #yiv7923565234 div.yiv7923565234photo-title a:visited {text-decoration:none;}#yiv7923565234 div#yiv7923565234ygrp-mlmsg #yiv7923565234ygrp-msg p a span.yiv7923565234yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7923565234 .yiv7923565234green {color:#628c2a;}#yiv7923565234 .yiv7923565234MsoNormal {margin:0 0 0 0;}#yiv7923565234 o {font-size:0;}#yiv7923565234 #yiv7923565234photos div {float:left;width:72px;}#yiv7923565234 #yiv7923565234photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7923565234 #yiv7923565234photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7923565234 #yiv7923565234reco-category {font-size:77%;}#yiv7923565234 #yiv7923565234reco-desc {font-size:77%;}#yiv7923565234 .yiv7923565234replbq {margin:4px;}#yiv7923565234 #yiv7923565234ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7923565234 #yiv7923565234ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7923565234 #yiv7923565234ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7923565234 #yiv7923565234ygrp-mlmsg select, #yiv7923565234 input, #yiv7923565234 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7923565234 #yiv7923565234ygrp-mlmsg pre, #yiv7923565234 code {font:115% monospace;}#yiv7923565234 #yiv7923565234ygrp-mlmsg * {line-height:1.22em;}#yiv7923565234 #yiv7923565234ygrp-mlmsg #yiv7923565234logo {padding-bottom:10px;}#yiv7923565234 #yiv7923565234ygrp-msg p a {font-family:Verdana;}#yiv7923565234 #yiv7923565234ygrp-msg p#yiv7923565234attach-count span {color:#1E66AE;font-weight:700;}#yiv7923565234 #yiv7923565234ygrp-reco #yiv7923565234reco-head {color:#ff7900;font-weight:700;}#yiv7923565234 #yiv7923565234ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ov li a {font-size:130%;text-decoration:none;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7923565234 #yiv7923565234ygrp-sponsor #yiv7923565234ov ul {margin:0;padding:0 0 0 8px;}#yiv7923565234 #yiv7923565234ygrp-text {font-family:Georgia;}#yiv7923565234 #yiv7923565234ygrp-text p {margin:0 0 1em 0;}#yiv7923565234 #yiv7923565234ygrp-text tt {font-size:120%;}#yiv7923565234 #yiv7923565234ygrp-vital ul li:last-child {border-right:none !important;}#yiv7923565234

Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Agus,Coba ketik formula ini pada sel D3,=IF(AND(B8=15,C8>=80%),35,IF(AND(B8=15,C8<=80%),C8/80%*35,IF(B8<15,0)))
kemudian copy ke bawah.
Formatnya Number 2 digit.
Salam,HK
From: "Agus Suyanto agus.suyanto@hino.co.id [XL-mania]" <XL-mania@yahoogroups.com>
To: XL-mania@yahoogroups.com
Sent: Monday, 22 December 2014, 11:06
Subject: ]] XL-mania [[ Multiple kriteria [1 Attachment]

  Dear pakar excel,   Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.   Terima kasih atas bantuannya.   Rgds,   Agus     #yiv1691993797 #yiv1691993797 -- #yiv1691993797ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1691993797 #yiv1691993797ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1691993797 #yiv1691993797ygrp-mkp #yiv1691993797hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1691993797 #yiv1691993797ygrp-mkp #yiv1691993797ads {margin-bottom:10px;}#yiv1691993797 #yiv1691993797ygrp-mkp .yiv1691993797ad {padding:0 0;}#yiv1691993797 #yiv1691993797ygrp-mkp .yiv1691993797ad p {margin:0;}#yiv1691993797 #yiv1691993797ygrp-mkp .yiv1691993797ad a {color:#0000ff;text-decoration:none;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ygrp-lc {font-family:Arial;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ygrp-lc #yiv1691993797hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ygrp-lc .yiv1691993797ad {margin-bottom:10px;padding:0 0;}#yiv1691993797 #yiv1691993797actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1691993797 #yiv1691993797activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1691993797 #yiv1691993797activity span {font-weight:700;}#yiv1691993797 #yiv1691993797activity span:first-child {text-transform:uppercase;}#yiv1691993797 #yiv1691993797activity span a {color:#5085b6;text-decoration:none;}#yiv1691993797 #yiv1691993797activity span span {color:#ff7900;}#yiv1691993797 #yiv1691993797activity span .yiv1691993797underline {text-decoration:underline;}#yiv1691993797 .yiv1691993797attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1691993797 .yiv1691993797attach div a {text-decoration:none;}#yiv1691993797 .yiv1691993797attach img {border:none;padding-right:5px;}#yiv1691993797 .yiv1691993797attach label {display:block;margin-bottom:5px;}#yiv1691993797 .yiv1691993797attach label a {text-decoration:none;}#yiv1691993797 blockquote {margin:0 0 0 4px;}#yiv1691993797 .yiv1691993797bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1691993797 .yiv1691993797bold a {text-decoration:none;}#yiv1691993797 dd.yiv1691993797last p a {font-family:Verdana;font-weight:700;}#yiv1691993797 dd.yiv1691993797last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1691993797 dd.yiv1691993797last p span.yiv1691993797yshortcuts {margin-right:0;}#yiv1691993797 div.yiv1691993797attach-table div div a {text-decoration:none;}#yiv1691993797 div.yiv1691993797attach-table {width:400px;}#yiv1691993797 div.yiv1691993797file-title a, #yiv1691993797 div.yiv1691993797file-title a:active, #yiv1691993797 div.yiv1691993797file-title a:hover, #yiv1691993797 div.yiv1691993797file-title a:visited {text-decoration:none;}#yiv1691993797 div.yiv1691993797photo-title a, #yiv1691993797 div.yiv1691993797photo-title a:active, #yiv1691993797 div.yiv1691993797photo-title a:hover, #yiv1691993797 div.yiv1691993797photo-title a:visited {text-decoration:none;}#yiv1691993797 div#yiv1691993797ygrp-mlmsg #yiv1691993797ygrp-msg p a span.yiv1691993797yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1691993797 .yiv1691993797green {color:#628c2a;}#yiv1691993797 .yiv1691993797MsoNormal {margin:0 0 0 0;}#yiv1691993797 o {font-size:0;}#yiv1691993797 #yiv1691993797photos div {float:left;width:72px;}#yiv1691993797 #yiv1691993797photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1691993797 #yiv1691993797photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1691993797 #yiv1691993797reco-category {font-size:77%;}#yiv1691993797 #yiv1691993797reco-desc {font-size:77%;}#yiv1691993797 .yiv1691993797replbq {margin:4px;}#yiv1691993797 #yiv1691993797ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1691993797 #yiv1691993797ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1691993797 #yiv1691993797ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1691993797 #yiv1691993797ygrp-mlmsg select, #yiv1691993797 input, #yiv1691993797 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1691993797 #yiv1691993797ygrp-mlmsg pre, #yiv1691993797 code {font:115% monospace;}#yiv1691993797 #yiv1691993797ygrp-mlmsg * {line-height:1.22em;}#yiv1691993797 #yiv1691993797ygrp-mlmsg #yiv1691993797logo {padding-bottom:10px;}#yiv1691993797 #yiv1691993797ygrp-msg p a {font-family:Verdana;}#yiv1691993797 #yiv1691993797ygrp-msg p#yiv1691993797attach-count span {color:#1E66AE;font-weight:700;}#yiv1691993797 #yiv1691993797ygrp-reco #yiv1691993797reco-head {color:#ff7900;font-weight:700;}#yiv1691993797 #yiv1691993797ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ov li a {font-size:130%;text-decoration:none;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1691993797 #yiv1691993797ygrp-sponsor #yiv1691993797ov ul {margin:0;padding:0 0 0 8px;}#yiv1691993797 #yiv1691993797ygrp-text {font-family:Georgia;}#yiv1691993797 #yiv1691993797ygrp-text p {margin:0 0 1em 0;}#yiv1691993797 #yiv1691993797ygrp-text tt {font-size:120%;}#yiv1691993797 #yiv1691993797ygrp-vital ul li:last-child {border-right:none !important;}#yiv1691993797

Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"Inv-WDC-Reconsile, ID3P-Linfox"

Dear Pak Agus,

Mungkin formula terlampir bisa jadi solusi,


IF(AND(B3=15,C3>80%),35,IF(AND(B3=15,C3<=80%),C3/80%*35,IF(B3<=15,0)))

Salam,


Kus
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: 22 Desember 2014 11:07
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Multiple kriteria [1 Attachment]


Dear pakar excel,

Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.

Terima kasih atas bantuannya.

Rgds,

Agus



Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"HERIS PAMUNTJAR" heris2001

Sdr Agus ...rumus untuk hal dimaksud sbb : 
=IF(B3<15;0;IF(AND(B3=15;C3>=80%);35;C3/80%*35))


On Tuesday, December 23, 2014 12:44 PM, "Agus Suyanto agus.suyanto@hino.co.id [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Dear pakar excel,   Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.   Terima kasih atas bantuannya.   Rgds,   Agus     #yiv3523708803 #yiv3523708803 -- #yiv3523708803ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3523708803 #yiv3523708803ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3523708803 #yiv3523708803ygrp-mkp #yiv3523708803hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3523708803 #yiv3523708803ygrp-mkp #yiv3523708803ads {margin-bottom:10px;}#yiv3523708803 #yiv3523708803ygrp-mkp .yiv3523708803ad {padding:0 0;}#yiv3523708803 #yiv3523708803ygrp-mkp .yiv3523708803ad p {margin:0;}#yiv3523708803 #yiv3523708803ygrp-mkp .yiv3523708803ad a {color:#0000ff;text-decoration:none;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ygrp-lc {font-family:Arial;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ygrp-lc #yiv3523708803hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ygrp-lc .yiv3523708803ad {margin-bottom:10px;padding:0 0;}#yiv3523708803 #yiv3523708803actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3523708803 #yiv3523708803activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3523708803 #yiv3523708803activity span {font-weight:700;}#yiv3523708803 #yiv3523708803activity span:first-child {text-transform:uppercase;}#yiv3523708803 #yiv3523708803activity span a {color:#5085b6;text-decoration:none;}#yiv3523708803 #yiv3523708803activity span span {color:#ff7900;}#yiv3523708803 #yiv3523708803activity span .yiv3523708803underline {text-decoration:underline;}#yiv3523708803 .yiv3523708803attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3523708803 .yiv3523708803attach div a {text-decoration:none;}#yiv3523708803 .yiv3523708803attach img {border:none;padding-right:5px;}#yiv3523708803 .yiv3523708803attach label {display:block;margin-bottom:5px;}#yiv3523708803 .yiv3523708803attach label a {text-decoration:none;}#yiv3523708803 blockquote {margin:0 0 0 4px;}#yiv3523708803 .yiv3523708803bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3523708803 .yiv3523708803bold a {text-decoration:none;}#yiv3523708803 dd.yiv3523708803last p a {font-family:Verdana;font-weight:700;}#yiv3523708803 dd.yiv3523708803last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3523708803 dd.yiv3523708803last p span.yiv3523708803yshortcuts {margin-right:0;}#yiv3523708803 div.yiv3523708803attach-table div div a {text-decoration:none;}#yiv3523708803 div.yiv3523708803attach-table {width:400px;}#yiv3523708803 div.yiv3523708803file-title a, #yiv3523708803 div.yiv3523708803file-title a:active, #yiv3523708803 div.yiv3523708803file-title a:hover, #yiv3523708803 div.yiv3523708803file-title a:visited {text-decoration:none;}#yiv3523708803 div.yiv3523708803photo-title a, #yiv3523708803 div.yiv3523708803photo-title a:active, #yiv3523708803 div.yiv3523708803photo-title a:hover, #yiv3523708803 div.yiv3523708803photo-title a:visited {text-decoration:none;}#yiv3523708803 div#yiv3523708803ygrp-mlmsg #yiv3523708803ygrp-msg p a span.yiv3523708803yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3523708803 .yiv3523708803green {color:#628c2a;}#yiv3523708803 .yiv3523708803MsoNormal {margin:0 0 0 0;}#yiv3523708803 o {font-size:0;}#yiv3523708803 #yiv3523708803photos div {float:left;width:72px;}#yiv3523708803 #yiv3523708803photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3523708803 #yiv3523708803photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3523708803 #yiv3523708803reco-category {font-size:77%;}#yiv3523708803 #yiv3523708803reco-desc {font-size:77%;}#yiv3523708803 .yiv3523708803replbq {margin:4px;}#yiv3523708803 #yiv3523708803ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3523708803 #yiv3523708803ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3523708803 #yiv3523708803ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3523708803 #yiv3523708803ygrp-mlmsg select, #yiv3523708803 input, #yiv3523708803 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3523708803 #yiv3523708803ygrp-mlmsg pre, #yiv3523708803 code {font:115% monospace;}#yiv3523708803 #yiv3523708803ygrp-mlmsg * {line-height:1.22em;}#yiv3523708803 #yiv3523708803ygrp-mlmsg #yiv3523708803logo {padding-bottom:10px;}#yiv3523708803 #yiv3523708803ygrp-msg p a {font-family:Verdana;}#yiv3523708803 #yiv3523708803ygrp-msg p#yiv3523708803attach-count span {color:#1E66AE;font-weight:700;}#yiv3523708803 #yiv3523708803ygrp-reco #yiv3523708803reco-head {color:#ff7900;font-weight:700;}#yiv3523708803 #yiv3523708803ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ov li a {font-size:130%;text-decoration:none;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3523708803 #yiv3523708803ygrp-sponsor #yiv3523708803ov ul {margin:0;padding:0 0 0 8px;}#yiv3523708803 #yiv3523708803ygrp-text {font-family:Georgia;}#yiv3523708803 #yiv3523708803ygrp-text p {margin:0 0 1em 0;}#yiv3523708803 #yiv3523708803ygrp-text tt {font-size:120%;}#yiv3523708803 #yiv3523708803ygrp-vital ul li:last-child {border-right:none !important;}#yiv3523708803

Fri Dec 26, 2014 5:40 am (PST) . Posted by:

"rhonal iron" iron_sagit


Dear All,
mohon bantuannya, bagaimana formula yang tepat untuk bisa menarik data pada kolom B, jika data pada Kolom C sama dengan data pada Kolom D3. Seperti contoh terlampir. Terima kasih.




Best Regards,

iron

Fri Dec 26, 2014 5:40 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba fie terlampir- Pertama2 mencari Unique validation list- Yang kedua adalah membuat list dengan fungsi Index dan Small(IF....
Salam,HK
From: "Eko Ludiono waneko989@ymail.com [XL-mania]" <XL-mania@yahoogroups.com>
To: XL-mania@yahoogroups.com
Sent: Monday, 15 December 2014, 17:07
Subject: ]] XL-mania [[ Membuat List sesuai apa yang di inginkan [1 Attachment]

  Dear Temans,
Mohon bantuanya para suhu suhu excel,

Thx,

  #yiv0204058480 #yiv0204058480 -- #yiv0204058480ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0204058480 #yiv0204058480ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0204058480 #yiv0204058480ygrp-mkp #yiv0204058480hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0204058480 #yiv0204058480ygrp-mkp #yiv0204058480ads {margin-bottom:10px;}#yiv0204058480 #yiv0204058480ygrp-mkp .yiv0204058480ad {padding:0 0;}#yiv0204058480 #yiv0204058480ygrp-mkp .yiv0204058480ad p {margin:0;}#yiv0204058480 #yiv0204058480ygrp-mkp .yiv0204058480ad a {color:#0000ff;text-decoration:none;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ygrp-lc {font-family:Arial;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ygrp-lc #yiv0204058480hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ygrp-lc .yiv0204058480ad {margin-bottom:10px;padding:0 0;}#yiv0204058480 #yiv0204058480actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0204058480 #yiv0204058480activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0204058480 #yiv0204058480activity span {font-weight:700;}#yiv0204058480 #yiv0204058480activity span:first-child {text-transform:uppercase;}#yiv0204058480 #yiv0204058480activity span a {color:#5085b6;text-decoration:none;}#yiv0204058480 #yiv0204058480activity span span {color:#ff7900;}#yiv0204058480 #yiv0204058480activity span .yiv0204058480underline {text-decoration:underline;}#yiv0204058480 .yiv0204058480attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0204058480 .yiv0204058480attach div a {text-decoration:none;}#yiv0204058480 .yiv0204058480attach img {border:none;padding-right:5px;}#yiv0204058480 .yiv0204058480attach label {display:block;margin-bottom:5px;}#yiv0204058480 .yiv0204058480attach label a {text-decoration:none;}#yiv0204058480 blockquote {margin:0 0 0 4px;}#yiv0204058480 .yiv0204058480bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0204058480 .yiv0204058480bold a {text-decoration:none;}#yiv0204058480 dd.yiv0204058480last p a {font-family:Verdana;font-weight:700;}#yiv0204058480 dd.yiv0204058480last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0204058480 dd.yiv0204058480last p span.yiv0204058480yshortcuts {margin-right:0;}#yiv0204058480 div.yiv0204058480attach-table div div a {text-decoration:none;}#yiv0204058480 div.yiv0204058480attach-table {width:400px;}#yiv0204058480 div.yiv0204058480file-title a, #yiv0204058480 div.yiv0204058480file-title a:active, #yiv0204058480 div.yiv0204058480file-title a:hover, #yiv0204058480 div.yiv0204058480file-title a:visited {text-decoration:none;}#yiv0204058480 div.yiv0204058480photo-title a, #yiv0204058480 div.yiv0204058480photo-title a:active, #yiv0204058480 div.yiv0204058480photo-title a:hover, #yiv0204058480 div.yiv0204058480photo-title a:visited {text-decoration:none;}#yiv0204058480 div#yiv0204058480ygrp-mlmsg #yiv0204058480ygrp-msg p a span.yiv0204058480yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0204058480 .yiv0204058480green {color:#628c2a;}#yiv0204058480 .yiv0204058480MsoNormal {margin:0 0 0 0;}#yiv0204058480 o {font-size:0;}#yiv0204058480 #yiv0204058480photos div {float:left;width:72px;}#yiv0204058480 #yiv0204058480photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0204058480 #yiv0204058480photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0204058480 #yiv0204058480reco-category {font-size:77%;}#yiv0204058480 #yiv0204058480reco-desc {font-size:77%;}#yiv0204058480 .yiv0204058480replbq {margin:4px;}#yiv0204058480 #yiv0204058480ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0204058480 #yiv0204058480ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0204058480 #yiv0204058480ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0204058480 #yiv0204058480ygrp-mlmsg select, #yiv0204058480 input, #yiv0204058480 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0204058480 #yiv0204058480ygrp-mlmsg pre, #yiv0204058480 code {font:115% monospace;}#yiv0204058480 #yiv0204058480ygrp-mlmsg * {line-height:1.22em;}#yiv0204058480 #yiv0204058480ygrp-mlmsg #yiv0204058480logo {padding-bottom:10px;}#yiv0204058480 #yiv0204058480ygrp-msg p a {font-family:Verdana;}#yiv0204058480 #yiv0204058480ygrp-msg p#yiv0204058480attach-count span {color:#1E66AE;font-weight:700;}#yiv0204058480 #yiv0204058480ygrp-reco #yiv0204058480reco-head {color:#ff7900;font-weight:700;}#yiv0204058480 #yiv0204058480ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ov li a {font-size:130%;text-decoration:none;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0204058480 #yiv0204058480ygrp-sponsor #yiv0204058480ov ul {margin:0;padding:0 0 0 8px;}#yiv0204058480 #yiv0204058480ygrp-text {font-family:Georgia;}#yiv0204058480 #yiv0204058480ygrp-text p {margin:0 0 1em 0;}#yiv0204058480 #yiv0204058480ygrp-text tt {font-size:120%;}#yiv0204058480 #yiv0204058480ygrp-vital ul li:last-child {border-right:none !important;}#yiv0204058480

Fri Dec 26, 2014 5:40 am (PST) . Posted by:

"HERIS PAMUNTJAR" heris2001

Sdr. Eko ...Rumus di D5  adalah  =IF(D4<=0;0;IF(D4>1,2;2;1))

atau lihat file attached

On Tuesday, December 23, 2014 12:41 PM, "'Eko Nurcahyanto' s.eko.nur@musashi.co.id [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Dear Suhu exel,Mohon bantuan formula terlampir.  Terimakasih,ECho   #yiv7377039421 #yiv7377039421 -- #yiv7377039421ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7377039421 #yiv7377039421ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7377039421 #yiv7377039421ygrp-mkp #yiv7377039421hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7377039421 #yiv7377039421ygrp-mkp #yiv7377039421ads {margin-bottom:10px;}#yiv7377039421 #yiv7377039421ygrp-mkp .yiv7377039421ad {padding:0 0;}#yiv7377039421 #yiv7377039421ygrp-mkp .yiv7377039421ad p {margin:0;}#yiv7377039421 #yiv7377039421ygrp-mkp .yiv7377039421ad a {color:#0000ff;text-decoration:none;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ygrp-lc {font-family:Arial;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ygrp-lc #yiv7377039421hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ygrp-lc .yiv7377039421ad {margin-bottom:10px;padding:0 0;}#yiv7377039421 #yiv7377039421actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7377039421 #yiv7377039421activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7377039421 #yiv7377039421activity span {font-weight:700;}#yiv7377039421 #yiv7377039421activity span:first-child {text-transform:uppercase;}#yiv7377039421 #yiv7377039421activity span a {color:#5085b6;text-decoration:none;}#yiv7377039421 #yiv7377039421activity span span {color:#ff7900;}#yiv7377039421 #yiv7377039421activity span .yiv7377039421underline {text-decoration:underline;}#yiv7377039421 .yiv7377039421attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7377039421 .yiv7377039421attach div a {text-decoration:none;}#yiv7377039421 .yiv7377039421attach img {border:none;padding-right:5px;}#yiv7377039421 .yiv7377039421attach label {display:block;margin-bottom:5px;}#yiv7377039421 .yiv7377039421attach label a {text-decoration:none;}#yiv7377039421 blockquote {margin:0 0 0 4px;}#yiv7377039421 .yiv7377039421bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7377039421 .yiv7377039421bold a {text-decoration:none;}#yiv7377039421 dd.yiv7377039421last p a {font-family:Verdana;font-weight:700;}#yiv7377039421 dd.yiv7377039421last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7377039421 dd.yiv7377039421last p span.yiv7377039421yshortcuts {margin-right:0;}#yiv7377039421 div.yiv7377039421attach-table div div a {text-decoration:none;}#yiv7377039421 div.yiv7377039421attach-table {width:400px;}#yiv7377039421 div.yiv7377039421file-title a, #yiv7377039421 div.yiv7377039421file-title a:active, #yiv7377039421 div.yiv7377039421file-title a:hover, #yiv7377039421 div.yiv7377039421file-title a:visited {text-decoration:none;}#yiv7377039421 div.yiv7377039421photo-title a, #yiv7377039421 div.yiv7377039421photo-title a:active, #yiv7377039421 div.yiv7377039421photo-title a:hover, #yiv7377039421 div.yiv7377039421photo-title a:visited {text-decoration:none;}#yiv7377039421 div#yiv7377039421ygrp-mlmsg #yiv7377039421ygrp-msg p a span.yiv7377039421yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7377039421 .yiv7377039421green {color:#628c2a;}#yiv7377039421 .yiv7377039421MsoNormal {margin:0 0 0 0;}#yiv7377039421 o {font-size:0;}#yiv7377039421 #yiv7377039421photos div {float:left;width:72px;}#yiv7377039421 #yiv7377039421photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7377039421 #yiv7377039421photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7377039421 #yiv7377039421reco-category {font-size:77%;}#yiv7377039421 #yiv7377039421reco-desc {font-size:77%;}#yiv7377039421 .yiv7377039421replbq {margin:4px;}#yiv7377039421 #yiv7377039421ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7377039421 #yiv7377039421ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7377039421 #yiv7377039421ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7377039421 #yiv7377039421ygrp-mlmsg select, #yiv7377039421 input, #yiv7377039421 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7377039421 #yiv7377039421ygrp-mlmsg pre, #yiv7377039421 code {font:115% monospace;}#yiv7377039421 #yiv7377039421ygrp-mlmsg * {line-height:1.22em;}#yiv7377039421 #yiv7377039421ygrp-mlmsg #yiv7377039421logo {padding-bottom:10px;}#yiv7377039421 #yiv7377039421ygrp-msg p a {font-family:Verdana;}#yiv7377039421 #yiv7377039421ygrp-msg p#yiv7377039421attach-count span {color:#1E66AE;font-weight:700;}#yiv7377039421 #yiv7377039421ygrp-reco #yiv7377039421reco-head {color:#ff7900;font-weight:700;}#yiv7377039421 #yiv7377039421ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ov li a {font-size:130%;text-decoration:none;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7377039421 #yiv7377039421ygrp-sponsor #yiv7377039421ov ul {margin:0;padding:0 0 0 8px;}#yiv7377039421 #yiv7377039421ygrp-text {font-family:Georgia;}#yiv7377039421 #yiv7377039421ygrp-text p {margin:0 0 1em 0;}#yiv7377039421 #yiv7377039421ygrp-text tt {font-size:120%;}#yiv7377039421 #yiv7377039421ygrp-vital ul li:last-child {border-right:none !important;}#yiv7377039421

Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"Winov X" winovx



=IF(AND(B3=15;C3>=80%);35;IF(AND(B3=15;C3<80%);C3/80%*35;0))semoga sesuai harapan

__Winarno__

Pada Senin, 22 Desember 2014 21:41, "Agus Suyanto agus.suyanto@hino.co.id [XL-mania]" <XL-mania@yahoogroups.com> menulis:


  Dear pakar excel,   Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.   Terima kasih atas bantuannya.   Rgds,   Agus     #yiv8032413509 #yiv8032413509 -- #yiv8032413509ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8032413509 #yiv8032413509ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8032413509 #yiv8032413509ygrp-mkp #yiv8032413509hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8032413509 #yiv8032413509ygrp-mkp #yiv8032413509ads {margin-bottom:10px;}#yiv8032413509 #yiv8032413509ygrp-mkp .yiv8032413509ad {padding:0 0;}#yiv8032413509 #yiv8032413509ygrp-mkp .yiv8032413509ad p {margin:0;}#yiv8032413509 #yiv8032413509ygrp-mkp .yiv8032413509ad a {color:#0000ff;text-decoration:none;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ygrp-lc {font-family:Arial;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ygrp-lc #yiv8032413509hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ygrp-lc .yiv8032413509ad {margin-bottom:10px;padding:0 0;}#yiv8032413509 #yiv8032413509actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8032413509 #yiv8032413509activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8032413509 #yiv8032413509activity span {font-weight:700;}#yiv8032413509 #yiv8032413509activity span:first-child {text-transform:uppercase;}#yiv8032413509 #yiv8032413509activity span a {color:#5085b6;text-decoration:none;}#yiv8032413509 #yiv8032413509activity span span {color:#ff7900;}#yiv8032413509 #yiv8032413509activity span .yiv8032413509underline {text-decoration:underline;}#yiv8032413509 .yiv8032413509attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8032413509 .yiv8032413509attach div a {text-decoration:none;}#yiv8032413509 .yiv8032413509attach img {border:none;padding-right:5px;}#yiv8032413509 .yiv8032413509attach label {display:block;margin-bottom:5px;}#yiv8032413509 .yiv8032413509attach label a {text-decoration:none;}#yiv8032413509 blockquote {margin:0 0 0 4px;}#yiv8032413509 .yiv8032413509bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8032413509 .yiv8032413509bold a {text-decoration:none;}#yiv8032413509 dd.yiv8032413509last p a {font-family:Verdana;font-weight:700;}#yiv8032413509 dd.yiv8032413509last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8032413509 dd.yiv8032413509last p span.yiv8032413509yshortcuts {margin-right:0;}#yiv8032413509 div.yiv8032413509attach-table div div a {text-decoration:none;}#yiv8032413509 div.yiv8032413509attach-table {width:400px;}#yiv8032413509 div.yiv8032413509file-title a, #yiv8032413509 div.yiv8032413509file-title a:active, #yiv8032413509 div.yiv8032413509file-title a:hover, #yiv8032413509 div.yiv8032413509file-title a:visited {text-decoration:none;}#yiv8032413509 div.yiv8032413509photo-title a, #yiv8032413509 div.yiv8032413509photo-title a:active, #yiv8032413509 div.yiv8032413509photo-title a:hover, #yiv8032413509 div.yiv8032413509photo-title a:visited {text-decoration:none;}#yiv8032413509 div#yiv8032413509ygrp-mlmsg #yiv8032413509ygrp-msg p a span.yiv8032413509yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8032413509 .yiv8032413509green {color:#628c2a;}#yiv8032413509 .yiv8032413509MsoNormal {margin:0 0 0 0;}#yiv8032413509 o {font-size:0;}#yiv8032413509 #yiv8032413509photos div {float:left;width:72px;}#yiv8032413509 #yiv8032413509photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8032413509 #yiv8032413509photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8032413509 #yiv8032413509reco-category {font-size:77%;}#yiv8032413509 #yiv8032413509reco-desc {font-size:77%;}#yiv8032413509 .yiv8032413509replbq {margin:4px;}#yiv8032413509 #yiv8032413509ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8032413509 #yiv8032413509ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8032413509 #yiv8032413509ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8032413509 #yiv8032413509ygrp-mlmsg select, #yiv8032413509 input, #yiv8032413509 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8032413509 #yiv8032413509ygrp-mlmsg pre, #yiv8032413509 code {font:115% monospace;}#yiv8032413509 #yiv8032413509ygrp-mlmsg * {line-height:1.22em;}#yiv8032413509 #yiv8032413509ygrp-mlmsg #yiv8032413509logo {padding-bottom:10px;}#yiv8032413509 #yiv8032413509ygrp-msg p a {font-family:Verdana;}#yiv8032413509 #yiv8032413509ygrp-msg p#yiv8032413509attach-count span {color:#1E66AE;font-weight:700;}#yiv8032413509 #yiv8032413509ygrp-reco #yiv8032413509reco-head {color:#ff7900;font-weight:700;}#yiv8032413509 #yiv8032413509ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ov li a {font-size:130%;text-decoration:none;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8032413509 #yiv8032413509ygrp-sponsor #yiv8032413509ov ul {margin:0;padding:0 0 0 8px;}#yiv8032413509 #yiv8032413509ygrp-text {font-family:Georgia;}#yiv8032413509 #yiv8032413509ygrp-text p {margin:0 0 1em 0;}#yiv8032413509 #yiv8032413509ygrp-text tt {font-size:120%;}#yiv8032413509 #yiv8032413509ygrp-vital ul li:last-child {border-right:none !important;}#yiv8032413509

Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"HERIS PAMUNTJAR" heris2001

Sdr. Trie ...kasus demikian membutuhkan Solver , lihat file attached

On Tuesday, December 23, 2014 12:39 PM, "triono_ea@yahoo.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Yth. Para Sahabat XL-mania
Mohon pencerahan untuk kasus yang saya hadapi, misal hasil dari suatu penjumlahan, dapatkah kita mencari dari hasil penjumlahan nilai yang  mana dari beberapa nilai yang ada (kasus terlampir)

Demikian atas bantuan Sahabat smua saya ucapkan terima kasih.
Salam,Trie
#yiv3121314150 #yiv3121314150 -- #yiv3121314150ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3121314150 #yiv3121314150ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3121314150 #yiv3121314150ygrp-mkp #yiv3121314150hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3121314150 #yiv3121314150ygrp-mkp #yiv3121314150ads {margin-bottom:10px;}#yiv3121314150 #yiv3121314150ygrp-mkp .yiv3121314150ad {padding:0 0;}#yiv3121314150 #yiv3121314150ygrp-mkp .yiv3121314150ad p {margin:0;}#yiv3121314150 #yiv3121314150ygrp-mkp .yiv3121314150ad a {color:#0000ff;text-decoration:none;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ygrp-lc {font-family:Arial;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ygrp-lc #yiv3121314150hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ygrp-lc .yiv3121314150ad {margin-bottom:10px;padding:0 0;}#yiv3121314150 #yiv3121314150actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3121314150 #yiv3121314150activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3121314150 #yiv3121314150activity span {font-weight:700;}#yiv3121314150 #yiv3121314150activity span:first-child {text-transform:uppercase;}#yiv3121314150 #yiv3121314150activity span a {color:#5085b6;text-decoration:none;}#yiv3121314150 #yiv3121314150activity span span {color:#ff7900;}#yiv3121314150 #yiv3121314150activity span .yiv3121314150underline {text-decoration:underline;}#yiv3121314150 .yiv3121314150attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3121314150 .yiv3121314150attach div a {text-decoration:none;}#yiv3121314150 .yiv3121314150attach img {border:none;padding-right:5px;}#yiv3121314150 .yiv3121314150attach label {display:block;margin-bottom:5px;}#yiv3121314150 .yiv3121314150attach label a {text-decoration:none;}#yiv3121314150 blockquote {margin:0 0 0 4px;}#yiv3121314150 .yiv3121314150bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3121314150 .yiv3121314150bold a {text-decoration:none;}#yiv3121314150 dd.yiv3121314150last p a {font-family:Verdana;font-weight:700;}#yiv3121314150 dd.yiv3121314150last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3121314150 dd.yiv3121314150last p span.yiv3121314150yshortcuts {margin-right:0;}#yiv3121314150 div.yiv3121314150attach-table div div a {text-decoration:none;}#yiv3121314150 div.yiv3121314150attach-table {width:400px;}#yiv3121314150 div.yiv3121314150file-title a, #yiv3121314150 div.yiv3121314150file-title a:active, #yiv3121314150 div.yiv3121314150file-title a:hover, #yiv3121314150 div.yiv3121314150file-title a:visited {text-decoration:none;}#yiv3121314150 div.yiv3121314150photo-title a, #yiv3121314150 div.yiv3121314150photo-title a:active, #yiv3121314150 div.yiv3121314150photo-title a:hover, #yiv3121314150 div.yiv3121314150photo-title a:visited {text-decoration:none;}#yiv3121314150 div#yiv3121314150ygrp-mlmsg #yiv3121314150ygrp-msg p a span.yiv3121314150yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3121314150 .yiv3121314150green {color:#628c2a;}#yiv3121314150 .yiv3121314150MsoNormal {margin:0 0 0 0;}#yiv3121314150 o {font-size:0;}#yiv3121314150 #yiv3121314150photos div {float:left;width:72px;}#yiv3121314150 #yiv3121314150photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3121314150 #yiv3121314150photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3121314150 #yiv3121314150reco-category {font-size:77%;}#yiv3121314150 #yiv3121314150reco-desc {font-size:77%;}#yiv3121314150 .yiv3121314150replbq {margin:4px;}#yiv3121314150 #yiv3121314150ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3121314150 #yiv3121314150ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3121314150 #yiv3121314150ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3121314150 #yiv3121314150ygrp-mlmsg select, #yiv3121314150 input, #yiv3121314150 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3121314150 #yiv3121314150ygrp-mlmsg pre, #yiv3121314150 code {font:115% monospace;}#yiv3121314150 #yiv3121314150ygrp-mlmsg * {line-height:1.22em;}#yiv3121314150 #yiv3121314150ygrp-mlmsg #yiv3121314150logo {padding-bottom:10px;}#yiv3121314150 #yiv3121314150ygrp-msg p a {font-family:Verdana;}#yiv3121314150 #yiv3121314150ygrp-msg p#yiv3121314150attach-count span {color:#1E66AE;font-weight:700;}#yiv3121314150 #yiv3121314150ygrp-reco #yiv3121314150reco-head {color:#ff7900;font-weight:700;}#yiv3121314150 #yiv3121314150ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ov li a {font-size:130%;text-decoration:none;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3121314150 #yiv3121314150ygrp-sponsor #yiv3121314150ov ul {margin:0;padding:0 0 0 8px;}#yiv3121314150 #yiv3121314150ygrp-text {font-family:Georgia;}#yiv3121314150 #yiv3121314150ygrp-text p {margin:0 0 1em 0;}#yiv3121314150 #yiv3121314150ygrp-text tt {font-size:120%;}#yiv3121314150 #yiv3121314150ygrp-vital ul li:last-child {border-right:none !important;}#yiv3121314150

Fri Dec 26, 2014 5:42 am (PST) . Posted by:

"Ilyas Kurniawan" ilyas.kurniawan@rocketmail.com

Saya bukan "suhu" tapi bolehlah kiranya membantu Terlampir semoga sesuai harapan, . . .

SalamIlyas


Pada Selasa, 23 Desember 2014 12:41, "'Eko Nurcahyanto' s.eko.nur@musashi.co.id [XL-mania]" <XL-mania@yahoogroups.com> menulis:


  Dear Suhu exel,Mohon bantuan formula terlampir.  Terimakasih,ECho   #yiv3004940103 #yiv3004940103 -- #yiv3004940103ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3004940103 #yiv3004940103ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3004940103 #yiv3004940103ygrp-mkp #yiv3004940103hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3004940103 #yiv3004940103ygrp-mkp #yiv3004940103ads {margin-bottom:10px;}#yiv3004940103 #yiv3004940103ygrp-mkp .yiv3004940103ad {padding:0 0;}#yiv3004940103 #yiv3004940103ygrp-mkp .yiv3004940103ad p {margin:0;}#yiv3004940103 #yiv3004940103ygrp-mkp .yiv3004940103ad a {color:#0000ff;text-decoration:none;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ygrp-lc {font-family:Arial;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ygrp-lc #yiv3004940103hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ygrp-lc .yiv3004940103ad {margin-bottom:10px;padding:0 0;}#yiv3004940103 #yiv3004940103actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3004940103 #yiv3004940103activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3004940103 #yiv3004940103activity span {font-weight:700;}#yiv3004940103 #yiv3004940103activity span:first-child {text-transform:uppercase;}#yiv3004940103 #yiv3004940103activity span a {color:#5085b6;text-decoration:none;}#yiv3004940103 #yiv3004940103activity span span {color:#ff7900;}#yiv3004940103 #yiv3004940103activity span .yiv3004940103underline {text-decoration:underline;}#yiv3004940103 .yiv3004940103attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3004940103 .yiv3004940103attach div a {text-decoration:none;}#yiv3004940103 .yiv3004940103attach img {border:none;padding-right:5px;}#yiv3004940103 .yiv3004940103attach label {display:block;margin-bottom:5px;}#yiv3004940103 .yiv3004940103attach label a {text-decoration:none;}#yiv3004940103 blockquote {margin:0 0 0 4px;}#yiv3004940103 .yiv3004940103bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3004940103 .yiv3004940103bold a {text-decoration:none;}#yiv3004940103 dd.yiv3004940103last p a {font-family:Verdana;font-weight:700;}#yiv3004940103 dd.yiv3004940103last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3004940103 dd.yiv3004940103last p span.yiv3004940103yshortcuts {margin-right:0;}#yiv3004940103 div.yiv3004940103attach-table div div a {text-decoration:none;}#yiv3004940103 div.yiv3004940103attach-table {width:400px;}#yiv3004940103 div.yiv3004940103file-title a, #yiv3004940103 div.yiv3004940103file-title a:active, #yiv3004940103 div.yiv3004940103file-title a:hover, #yiv3004940103 div.yiv3004940103file-title a:visited {text-decoration:none;}#yiv3004940103 div.yiv3004940103photo-title a, #yiv3004940103 div.yiv3004940103photo-title a:active, #yiv3004940103 div.yiv3004940103photo-title a:hover, #yiv3004940103 div.yiv3004940103photo-title a:visited {text-decoration:none;}#yiv3004940103 div#yiv3004940103ygrp-mlmsg #yiv3004940103ygrp-msg p a span.yiv3004940103yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3004940103 .yiv3004940103green {color:#628c2a;}#yiv3004940103 .yiv3004940103MsoNormal {margin:0 0 0 0;}#yiv3004940103 o {font-size:0;}#yiv3004940103 #yiv3004940103photos div {float:left;width:72px;}#yiv3004940103 #yiv3004940103photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3004940103 #yiv3004940103photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3004940103 #yiv3004940103reco-category {font-size:77%;}#yiv3004940103 #yiv3004940103reco-desc {font-size:77%;}#yiv3004940103 .yiv3004940103replbq {margin:4px;}#yiv3004940103 #yiv3004940103ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3004940103 #yiv3004940103ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3004940103 #yiv3004940103ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3004940103 #yiv3004940103ygrp-mlmsg select, #yiv3004940103 input, #yiv3004940103 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3004940103 #yiv3004940103ygrp-mlmsg pre, #yiv3004940103 code {font:115% monospace;}#yiv3004940103 #yiv3004940103ygrp-mlmsg * {line-height:1.22em;}#yiv3004940103 #yiv3004940103ygrp-mlmsg #yiv3004940103logo {padding-bottom:10px;}#yiv3004940103 #yiv3004940103ygrp-msg p a {font-family:Verdana;}#yiv3004940103 #yiv3004940103ygrp-msg p#yiv3004940103attach-count span {color:#1E66AE;font-weight:700;}#yiv3004940103 #yiv3004940103ygrp-reco #yiv3004940103reco-head {color:#ff7900;font-weight:700;}#yiv3004940103 #yiv3004940103ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ov li a {font-size:130%;text-decoration:none;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3004940103 #yiv3004940103ygrp-sponsor #yiv3004940103ov ul {margin:0;padding:0 0 0 8px;}#yiv3004940103 #yiv3004940103ygrp-text {font-family:Georgia;}#yiv3004940103 #yiv3004940103ygrp-text p {margin:0 0 1em 0;}#yiv3004940103 #yiv3004940103ygrp-text tt {font-size:120%;}#yiv3004940103 #yiv3004940103ygrp-vital ul li:last-child {border-right:none !important;}#yiv3004940103

Fri Dec 26, 2014 5:43 am (PST) . Posted by:

ilyas.kurniawan@rocketmail.com

Saya bukan "suhu" tapi bolehlah kiranya membantu
Terlampir semoga sesuai harapan, . . .



Salam
Ilyas




Fri Dec 26, 2014 5:56 am (PST) . Posted by:

adeha_182

Mohon dibantu dengan sangat, saya punya file excel yang berisi schedule dgn grafik chart 18 buah. nah ketika saya akan saya edit di bagian nama2 orang yg tnda tangan kenapa excel jadi hang?bahkan utk skedar copy paste pun jadi hang.mohon solusinya...
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com
Diposting oleh EXCEL FEED LEARNING di 03.17

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)