Terimakasih Kakak.... iya selama ini saya mengunkana manual dg IF sum, akan
tetapai IF sum hanya berlaku hingga header ke -11 saja. nah bagaimana jika
Headernya 30 an.
Pada Selasa, 28 Januari 2020 14.44.08 WIB, Raden Saputra
[email protected] [XL-mania] <[email protected]> menulis:
Dear [email protected],
coba formula :
"=IF(SUM($D2:D2)>=95;"0,01";IF(SUM($D2:E2)>=95;"0,03";IF(SUM($D2:F2)>=95;"0,05";IF(SUM($D2:G2)>=95;"0,07";IF(SUM($D2:H2)>=95;"0,85";IF(SUM($D2:I2)>=95;"0,87";IF(SUM($D2:J2)>=95;"0,89";"")))))))"
Regards
Raden
On Tue, Jan 28, 2020 at 10:36 AM [email protected] [XL-mania]
<[email protected]> wrote:
Mohon maaf sebelumnya, karena infonya tidak detail, pada intinya saya hendak
mencari jumlah dari Header D1 Ke Header J1 yang jumlahnya minimal >=95..
Misalkan :
ADI => sum (D2: J2) yang >= 95 , ternyata ada di Header 0.03 (E1)
Pada Intinya mencari jumlah maximum >=95 ada di header mana.
Pada Jumat, 24 Januari 2020 15.05.51 WIB, Idrus, Adi
<[email protected]> menulis:
Ini maksudnya gimana ya bu? bisa diperjelas kah
From: [email protected] [mailto:[email protected]]
Sent: Friday, January 24, 2020 10:35 AM
To: [email protected]
Subject: [SPAM] ]] XL-mania [[ Menentukan Nilai Maximum [1 Attachment]
Sahabat XL Mania,
saya ada kendala mengenai penggunaan nilai maximum di XL, mohon di bantu
bagamana cara menetukan nilai Maximum, jika menggunakan IF(sum) akan ada
limited di kolom 11
terimakasih atas bantuannya
--
Raden Saputra
#yiv8738073540 #yiv8738073540 -- #yiv8738073540ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8738073540
#yiv8738073540ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8738073540
#yiv8738073540ygrp-mkp #yiv8738073540hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8738073540 #yiv8738073540ygrp-mkp #yiv8738073540ads
{margin-bottom:10px;}#yiv8738073540 #yiv8738073540ygrp-mkp .yiv8738073540ad
{padding:0 0;}#yiv8738073540 #yiv8738073540ygrp-mkp .yiv8738073540ad p
{margin:0;}#yiv8738073540 #yiv8738073540ygrp-mkp .yiv8738073540ad a
{color:#0000ff;text-decoration:none;}#yiv8738073540 #yiv8738073540ygrp-sponsor
#yiv8738073540ygrp-lc {font-family:Arial;}#yiv8738073540
#yiv8738073540ygrp-sponsor #yiv8738073540ygrp-lc #yiv8738073540hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8738073540
#yiv8738073540ygrp-sponsor #yiv8738073540ygrp-lc .yiv8738073540ad
{margin-bottom:10px;padding:0 0;}#yiv8738073540 #yiv8738073540actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8738073540
#yiv8738073540activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8738073540
#yiv8738073540activity span {font-weight:700;}#yiv8738073540
#yiv8738073540activity span:first-child
{text-transform:uppercase;}#yiv8738073540 #yiv8738073540activity span a
{color:#5085b6;text-decoration:none;}#yiv8738073540 #yiv8738073540activity span
span {color:#ff7900;}#yiv8738073540 #yiv8738073540activity span
.yiv8738073540underline {text-decoration:underline;}#yiv8738073540
.yiv8738073540attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8738073540 .yiv8738073540attach div a
{text-decoration:none;}#yiv8738073540 .yiv8738073540attach img
{border:none;padding-right:5px;}#yiv8738073540 .yiv8738073540attach label
{display:block;margin-bottom:5px;}#yiv8738073540 .yiv8738073540attach label a
{text-decoration:none;}#yiv8738073540 blockquote {margin:0 0 0
4px;}#yiv8738073540 .yiv8738073540bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8738073540
.yiv8738073540bold a {text-decoration:none;}#yiv8738073540 dd.yiv8738073540last
p a {font-family:Verdana;font-weight:700;}#yiv8738073540 dd.yiv8738073540last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8738073540
dd.yiv8738073540last p span.yiv8738073540yshortcuts
{margin-right:0;}#yiv8738073540 div.yiv8738073540attach-table div div a
{text-decoration:none;}#yiv8738073540 div.yiv8738073540attach-table
{width:400px;}#yiv8738073540 div.yiv8738073540file-title a, #yiv8738073540
div.yiv8738073540file-title a:active, #yiv8738073540
div.yiv8738073540file-title a:hover, #yiv8738073540 div.yiv8738073540file-title
a:visited {text-decoration:none;}#yiv8738073540 div.yiv8738073540photo-title a,
#yiv8738073540 div.yiv8738073540photo-title a:active, #yiv8738073540
div.yiv8738073540photo-title a:hover, #yiv8738073540
div.yiv8738073540photo-title a:visited {text-decoration:none;}#yiv8738073540
div#yiv8738073540ygrp-mlmsg #yiv8738073540ygrp-msg p a
span.yiv8738073540yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8738073540
.yiv8738073540green {color:#628c2a;}#yiv8738073540 .yiv8738073540MsoNormal
{margin:0 0 0 0;}#yiv8738073540 o {font-size:0;}#yiv8738073540
#yiv8738073540photos div {float:left;width:72px;}#yiv8738073540
#yiv8738073540photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8738073540
#yiv8738073540photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8738073540
#yiv8738073540reco-category {font-size:77%;}#yiv8738073540
#yiv8738073540reco-desc {font-size:77%;}#yiv8738073540 .yiv8738073540replbq
{margin:4px;}#yiv8738073540 #yiv8738073540ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8738073540 #yiv8738073540ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8738073540
#yiv8738073540ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8738073540
#yiv8738073540ygrp-mlmsg select, #yiv8738073540 input, #yiv8738073540 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8738073540
#yiv8738073540ygrp-mlmsg pre, #yiv8738073540 code {font:115%
monospace;}#yiv8738073540 #yiv8738073540ygrp-mlmsg *
{line-height:1.22em;}#yiv8738073540 #yiv8738073540ygrp-mlmsg #yiv8738073540logo
{padding-bottom:10px;}#yiv8738073540 #yiv8738073540ygrp-msg p a
{font-family:Verdana;}#yiv8738073540 #yiv8738073540ygrp-msg
p#yiv8738073540attach-count span {color:#1E66AE;font-weight:700;}#yiv8738073540
#yiv8738073540ygrp-reco #yiv8738073540reco-head
{color:#ff7900;font-weight:700;}#yiv8738073540 #yiv8738073540ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8738073540 #yiv8738073540ygrp-sponsor
#yiv8738073540ov li a {font-size:130%;text-decoration:none;}#yiv8738073540
#yiv8738073540ygrp-sponsor #yiv8738073540ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8738073540
#yiv8738073540ygrp-sponsor #yiv8738073540ov ul {margin:0;padding:0 0 0
8px;}#yiv8738073540 #yiv8738073540ygrp-text
{font-family:Georgia;}#yiv8738073540 #yiv8738073540ygrp-text p {margin:0 0 1em
0;}#yiv8738073540 #yiv8738073540ygrp-text tt {font-size:120%;}#yiv8738073540
#yiv8738073540ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8738073540
