lebih lengkapnya suhu... nilai 85 seharusnya konversi 3.00 dan nilai 86
seharusnya konversi 3.01, namun hasilnya malah nilai 85 jadi 2.94 dan 86 jadi
3.00..
mohon bantuannya.. file terlampir.(sebelumnya)
salam.
Pada Kamis, 27 November 2014 19:05, Pukka Hamonangan Pardede
<[email protected]> menulis:
Mohon bantuannya sedikit lg suhu mr. kid, setelah saya melakukan seperti yg
bpk katakan.. formulanya berjalan.. namun ada sedikit kendalala... (masalah
pembulatan)
file terlampir.
regards.
Pada Kamis, 27 November 2014 9:30, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
oh begitu...
bagaimana kalau begini :
0. buka file lampiran dari saya tempo lalu (ada dua sheet kan)
1. buat sheet baru (bisa gak membuat sheet baru alias menambah sheet kosong
dalam sebuah workbook ?)
>> kalau gak bisa,coba lihat daftar sheet (persis dibawah sheet) [namanya
tab sheets]
-> klik yang paling kanan berbunyi Insert Worksheet kalau mousenya
digerakkan ke arahnya
2. copy paste tabel referensi (yang ada di salah satu sheet) ke sheet baru itu.
3. lihat sheet lama (bukan yang baru) pada salah satu cell berformula vlookup
4. ubah rujukan range dalam formula vlookup itu ke tabel referensi yang ada di
sheet baru tadi (jangan lupa untuk meng-absolute rujukan ke tabel referensi di
sheet baru itu, bisa kan, yak betul, yang pencet tombol F4 di keyboard supaya
tanda '$' dollar nya pindah-pindah sampai keluar 4 bijik tanda '$' dollar...)
5. selesai jika Anda sudah tahu cara membuat formula di Excel (misal formula
=a7 dsb, jika belum bisa membuat formula seperti =a7, maka sebaiknya mengenal
Excel lebih dulu).
Wassalam,
Kid.
On Thu, Nov 27, 2014 at 1:18 PM, Pukka Hamonangan Pardede
[email protected] [belajar-excel] <[email protected]> wrote:
nah.. seperti itu yg ada di kepala saya gan.. masalahnya.. saya tidak tahu
membuat yg seperti itu.. (maaf)sekiranya suhu berkenan memberikan penerapannya
pada file terlampir sebelumnya (file terlampir "real converting)
Pada Kamis, 27 November 2014 2:28, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Letakkan saja tabel referensi nya pada sebuah sheet tersendiri. Formula
merujuk ke sheet khusus tersebut. Sheet khusus tersebut di-hide. Akhirnya, jadi
seperti tabel referensi yang disimpan di kepala bukan ? Sama-sama ndak
kelihatan tapi ada.
Wassalam,
Kid.
2014-11-27 3:57 GMT+11:00 [email protected] [belajar-excel]
<[email protected]>:
terimakasih atas respon nya Suhu Mr.kidmaksut saya begini, ketentuan nilai
dan konversinya kita simpan di kepala.. (ketentuan konversi tadi tidak
disertakan dalam lembar kerja)
file terlampir,regards.
#yiv4892408926 -- #yiv4892408926ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4892408926
#yiv4892408926ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4892408926
#yiv4892408926ygrp-mkp #yiv4892408926hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4892408926 #yiv4892408926ygrp-mkp #yiv4892408926ads
{margin-bottom:10px;}#yiv4892408926 #yiv4892408926ygrp-mkp .yiv4892408926ad
{padding:0 0;}#yiv4892408926 #yiv4892408926ygrp-mkp .yiv4892408926ad p
{margin:0;}#yiv4892408926 #yiv4892408926ygrp-mkp .yiv4892408926ad a
{color:#0000ff;text-decoration:none;}#yiv4892408926 #yiv4892408926ygrp-sponsor
#yiv4892408926ygrp-lc {font-family:Arial;}#yiv4892408926
#yiv4892408926ygrp-sponsor #yiv4892408926ygrp-lc #yiv4892408926hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4892408926
#yiv4892408926ygrp-sponsor #yiv4892408926ygrp-lc .yiv4892408926ad
{margin-bottom:10px;padding:0 0;}#yiv4892408926 #yiv4892408926actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4892408926
#yiv4892408926activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4892408926
#yiv4892408926activity span {font-weight:700;}#yiv4892408926
#yiv4892408926activity span:first-child
{text-transform:uppercase;}#yiv4892408926 #yiv4892408926activity span a
{color:#5085b6;text-decoration:none;}#yiv4892408926 #yiv4892408926activity span
span {color:#ff7900;}#yiv4892408926 #yiv4892408926activity span
.yiv4892408926underline {text-decoration:underline;}#yiv4892408926
.yiv4892408926attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4892408926 .yiv4892408926attach div a
{text-decoration:none;}#yiv4892408926 .yiv4892408926attach img
{border:none;padding-right:5px;}#yiv4892408926 .yiv4892408926attach label
{display:block;margin-bottom:5px;}#yiv4892408926 .yiv4892408926attach label a
{text-decoration:none;}#yiv4892408926 blockquote {margin:0 0 0
4px;}#yiv4892408926 .yiv4892408926bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4892408926
.yiv4892408926bold a {text-decoration:none;}#yiv4892408926 dd.yiv4892408926last
p a {font-family:Verdana;font-weight:700;}#yiv4892408926 dd.yiv4892408926last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4892408926
dd.yiv4892408926last p span.yiv4892408926yshortcuts
{margin-right:0;}#yiv4892408926 div.yiv4892408926attach-table div div a
{text-decoration:none;}#yiv4892408926 div.yiv4892408926attach-table
{width:400px;}#yiv4892408926 div.yiv4892408926file-title a, #yiv4892408926
div.yiv4892408926file-title a:active, #yiv4892408926
div.yiv4892408926file-title a:hover, #yiv4892408926 div.yiv4892408926file-title
a:visited {text-decoration:none;}#yiv4892408926 div.yiv4892408926photo-title a,
#yiv4892408926 div.yiv4892408926photo-title a:active, #yiv4892408926
div.yiv4892408926photo-title a:hover, #yiv4892408926
div.yiv4892408926photo-title a:visited {text-decoration:none;}#yiv4892408926
div#yiv4892408926ygrp-mlmsg #yiv4892408926ygrp-msg p a
span.yiv4892408926yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4892408926
.yiv4892408926green {color:#628c2a;}#yiv4892408926 .yiv4892408926MsoNormal
{margin:0 0 0 0;}#yiv4892408926 o {font-size:0;}#yiv4892408926
#yiv4892408926photos div {float:left;width:72px;}#yiv4892408926
#yiv4892408926photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4892408926
#yiv4892408926photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4892408926
#yiv4892408926reco-category {font-size:77%;}#yiv4892408926
#yiv4892408926reco-desc {font-size:77%;}#yiv4892408926 .yiv4892408926replbq
{margin:4px;}#yiv4892408926 #yiv4892408926ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4892408926 #yiv4892408926ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4892408926
#yiv4892408926ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4892408926
#yiv4892408926ygrp-mlmsg select, #yiv4892408926 input, #yiv4892408926 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4892408926
#yiv4892408926ygrp-mlmsg pre, #yiv4892408926 code {font:115%
monospace;}#yiv4892408926 #yiv4892408926ygrp-mlmsg *
{line-height:1.22em;}#yiv4892408926 #yiv4892408926ygrp-mlmsg #yiv4892408926logo
{padding-bottom:10px;}#yiv4892408926 #yiv4892408926ygrp-msg p a
{font-family:Verdana;}#yiv4892408926 #yiv4892408926ygrp-msg
p#yiv4892408926attach-count span {color:#1E66AE;font-weight:700;}#yiv4892408926
#yiv4892408926ygrp-reco #yiv4892408926reco-head
{color:#ff7900;font-weight:700;}#yiv4892408926 #yiv4892408926ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4892408926 #yiv4892408926ygrp-sponsor
#yiv4892408926ov li a {font-size:130%;text-decoration:none;}#yiv4892408926
#yiv4892408926ygrp-sponsor #yiv4892408926ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4892408926
#yiv4892408926ygrp-sponsor #yiv4892408926ov ul {margin:0;padding:0 0 0
8px;}#yiv4892408926 #yiv4892408926ygrp-text
{font-family:Georgia;}#yiv4892408926 #yiv4892408926ygrp-text p {margin:0 0 1em
0;}#yiv4892408926 #yiv4892408926ygrp-text tt {font-size:120%;}#yiv4892408926
#yiv4892408926ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4892408926
