Terima kasih atas responnyamaksud saya untuk permasalahan saya :1. nilai
121.000.000 berada di rentang presentase 6,83 s.d 8,23... berapa persen
tepatnya nilai tersebut itu berlaku untuk rentang nilai tersebut berlaku untuk
seterusnya (Sebagai mana pada tabel file yang dikirim)
2. pertanyaan tambahan ... apabila nilai 121.000.000 dibagi dengan rentang
presentase untuk poin 1 6,83 s.d 8,23, poin 2 4,62 s.d 5.35 berapa nilai yang
didapat sehingga total tetap menjadi 121.000.000
terima kasih mohon maaf ada pertanyaan tambahan, atas perhatian dan masukannya
saya ucapkan banyak terima kasih
On Monday, March 4, 2019, 10:12:52 AM GMT+7, ghozi alkatiri
[email protected] [belajar-excel] <[email protected]> wrote:
mungkin ini yan dimaksud
=INDEX($E$8:$O$8,MATCH(D13,$D$5:$O$5*10^6))
formula array tekan (Control + Shift+enter)
wassalam Ghozi Alkatiri Pada Senin, 4 Maret 2019 09.52.46 WIB, imam cahyo
yuwono [email protected] [belajar-excel] <[email protected]> menulis:
Assalamualaikum Wr. Wb
mohon bantuan para master untuk mendapatkan nilai yang tepat untuk range nilai
berdasarkan persentase sehingga niali sesuai dengan jenjang yang telah
disyaratkanTerima kasihwasalamualaikum Wr. Wb
#yiv7953785328 #yiv7953785328 -- #yiv7953785328ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7953785328
#yiv7953785328ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7953785328
#yiv7953785328ygrp-mkp #yiv7953785328hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7953785328 #yiv7953785328ygrp-mkp #yiv7953785328ads
{margin-bottom:10px;}#yiv7953785328 #yiv7953785328ygrp-mkp .yiv7953785328ad
{padding:0 0;}#yiv7953785328 #yiv7953785328ygrp-mkp .yiv7953785328ad p
{margin:0;}#yiv7953785328 #yiv7953785328ygrp-mkp .yiv7953785328ad a
{color:#0000ff;text-decoration:none;}#yiv7953785328 #yiv7953785328ygrp-sponsor
#yiv7953785328ygrp-lc {font-family:Arial;}#yiv7953785328
#yiv7953785328ygrp-sponsor #yiv7953785328ygrp-lc #yiv7953785328hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7953785328
#yiv7953785328ygrp-sponsor #yiv7953785328ygrp-lc .yiv7953785328ad
{margin-bottom:10px;padding:0 0;}#yiv7953785328 #yiv7953785328actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7953785328
#yiv7953785328activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7953785328
#yiv7953785328activity span {font-weight:700;}#yiv7953785328
#yiv7953785328activity span:first-child
{text-transform:uppercase;}#yiv7953785328 #yiv7953785328activity span a
{color:#5085b6;text-decoration:none;}#yiv7953785328 #yiv7953785328activity span
span {color:#ff7900;}#yiv7953785328 #yiv7953785328activity span
.yiv7953785328underline {text-decoration:underline;}#yiv7953785328
.yiv7953785328attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7953785328 .yiv7953785328attach div a
{text-decoration:none;}#yiv7953785328 .yiv7953785328attach img
{border:none;padding-right:5px;}#yiv7953785328 .yiv7953785328attach label
{display:block;margin-bottom:5px;}#yiv7953785328 .yiv7953785328attach label a
{text-decoration:none;}#yiv7953785328 blockquote {margin:0 0 0
4px;}#yiv7953785328 .yiv7953785328bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7953785328
.yiv7953785328bold a {text-decoration:none;}#yiv7953785328 dd.yiv7953785328last
p a {font-family:Verdana;font-weight:700;}#yiv7953785328 dd.yiv7953785328last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7953785328
dd.yiv7953785328last p span.yiv7953785328yshortcuts
{margin-right:0;}#yiv7953785328 div.yiv7953785328attach-table div div a
{text-decoration:none;}#yiv7953785328 div.yiv7953785328attach-table
{width:400px;}#yiv7953785328 div.yiv7953785328file-title a, #yiv7953785328
div.yiv7953785328file-title a:active, #yiv7953785328
div.yiv7953785328file-title a:hover, #yiv7953785328 div.yiv7953785328file-title
a:visited {text-decoration:none;}#yiv7953785328 div.yiv7953785328photo-title a,
#yiv7953785328 div.yiv7953785328photo-title a:active, #yiv7953785328
div.yiv7953785328photo-title a:hover, #yiv7953785328
div.yiv7953785328photo-title a:visited {text-decoration:none;}#yiv7953785328
div#yiv7953785328ygrp-mlmsg #yiv7953785328ygrp-msg p a
span.yiv7953785328yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7953785328
.yiv7953785328green {color:#628c2a;}#yiv7953785328 .yiv7953785328MsoNormal
{margin:0 0 0 0;}#yiv7953785328 o {font-size:0;}#yiv7953785328
#yiv7953785328photos div {float:left;width:72px;}#yiv7953785328
#yiv7953785328photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7953785328
#yiv7953785328photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7953785328
#yiv7953785328reco-category {font-size:77%;}#yiv7953785328
#yiv7953785328reco-desc {font-size:77%;}#yiv7953785328 .yiv7953785328replbq
{margin:4px;}#yiv7953785328 #yiv7953785328ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7953785328 #yiv7953785328ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7953785328
#yiv7953785328ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7953785328
#yiv7953785328ygrp-mlmsg select, #yiv7953785328 input, #yiv7953785328 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7953785328
#yiv7953785328ygrp-mlmsg pre, #yiv7953785328 code {font:115%
monospace;}#yiv7953785328 #yiv7953785328ygrp-mlmsg *
{line-height:1.22em;}#yiv7953785328 #yiv7953785328ygrp-mlmsg #yiv7953785328logo
{padding-bottom:10px;}#yiv7953785328 #yiv7953785328ygrp-msg p a
{font-family:Verdana;}#yiv7953785328 #yiv7953785328ygrp-msg
p#yiv7953785328attach-count span {color:#1E66AE;font-weight:700;}#yiv7953785328
#yiv7953785328ygrp-reco #yiv7953785328reco-head
{color:#ff7900;font-weight:700;}#yiv7953785328 #yiv7953785328ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7953785328 #yiv7953785328ygrp-sponsor
#yiv7953785328ov li a {font-size:130%;text-decoration:none;}#yiv7953785328
#yiv7953785328ygrp-sponsor #yiv7953785328ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7953785328
#yiv7953785328ygrp-sponsor #yiv7953785328ov ul {margin:0;padding:0 0 0
8px;}#yiv7953785328 #yiv7953785328ygrp-text
{font-family:Georgia;}#yiv7953785328 #yiv7953785328ygrp-text p {margin:0 0 1em
0;}#yiv7953785328 #yiv7953785328ygrp-text tt {font-size:120%;}#yiv7953785328
#yiv7953785328ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7953785328
