yoo samsudin,mungkin dengan sedikit perubahan tabel refrensi menjadi

| BTU/h | Kapasitas |
|                60.000  | 4 PK |
|                32.000  | 3 1/2 PK |
|                30.000  | 3 PK |
|                20.000  | 2 1/2 PK |
|                18.000  | 2 PK |
|                  9.000  | 1 1/2 PK |
|                  7.000  | 1 PK |
|                  5.000  | 1/2 PK |


dan masukan formula :=LOOKUP( 2 ; 1 / ( C 16 : C 23 > = G 2 0 ) ; D 1 6 : D 2 3 
)
 pada H22, silahkan di coba
ganti karakter titik koma ";" menajdi koma "," bila regional setempet english
br,

odong nando
 


    Pada Sabtu, 21 November 2015 6:18, "Samsudin [email protected] 
[belajar-excel]" <[email protected]> menulis:
 

     Dear Master Excel,  Saya ingin membuat template tentang kapasitas AC (file 
terlampir), mohon bantuannya untuk bisa memberikan template tersebut lebih 
informative dan yang ingin diubah adalah pada cell H22, dimana disitu saya 
menggunakan formula if standar, apakah ada formula yang lebih simple? :    
Terima kasih atas bantuannya.  Terima kasihSamsudin   
| 
---------------------------------------------------------------------------------------------------


This message (including any attachments) contains confidential information 
intended
for a specific individual and purpose, and is protected by law. If you are not 
the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or 
the
taking of any action based on it, is strictly prohibited. No liability or 
responsibility
is accepted if information or data is, for whatever reason corrupted or does 
not reach
its intended recipient. No warranty is given that this email is free of 
viruses. The
views expressed in this email are, unless otherwise stated, those of the author 
and
not those of the Company or its management. The Company reserves the right to 
monitor,
intercept and block emails addressed to its users or take any other action in 
accordance
with its email use policy. |

  #yiv7969438658 -- #yiv7969438658ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7969438658 
#yiv7969438658ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7969438658 
#yiv7969438658ygrp-mkp #yiv7969438658hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7969438658 #yiv7969438658ygrp-mkp #yiv7969438658ads 
{margin-bottom:10px;}#yiv7969438658 #yiv7969438658ygrp-mkp .yiv7969438658ad 
{padding:0 0;}#yiv7969438658 #yiv7969438658ygrp-mkp .yiv7969438658ad p 
{margin:0;}#yiv7969438658 #yiv7969438658ygrp-mkp .yiv7969438658ad a 
{color:#0000ff;text-decoration:none;}#yiv7969438658 #yiv7969438658ygrp-sponsor 
#yiv7969438658ygrp-lc {font-family:Arial;}#yiv7969438658 
#yiv7969438658ygrp-sponsor #yiv7969438658ygrp-lc #yiv7969438658hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7969438658 
#yiv7969438658ygrp-sponsor #yiv7969438658ygrp-lc .yiv7969438658ad 
{margin-bottom:10px;padding:0 0;}#yiv7969438658 #yiv7969438658actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7969438658 
#yiv7969438658activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7969438658
 #yiv7969438658activity span {font-weight:700;}#yiv7969438658 
#yiv7969438658activity span:first-child 
{text-transform:uppercase;}#yiv7969438658 #yiv7969438658activity span a 
{color:#5085b6;text-decoration:none;}#yiv7969438658 #yiv7969438658activity span 
span {color:#ff7900;}#yiv7969438658 #yiv7969438658activity span 
.yiv7969438658underline {text-decoration:underline;}#yiv7969438658 
.yiv7969438658attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7969438658 .yiv7969438658attach div a 
{text-decoration:none;}#yiv7969438658 .yiv7969438658attach img 
{border:none;padding-right:5px;}#yiv7969438658 .yiv7969438658attach label 
{display:block;margin-bottom:5px;}#yiv7969438658 .yiv7969438658attach label a 
{text-decoration:none;}#yiv7969438658 blockquote {margin:0 0 0 
4px;}#yiv7969438658 .yiv7969438658bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7969438658 
.yiv7969438658bold a {text-decoration:none;}#yiv7969438658 dd.yiv7969438658last 
p a {font-family:Verdana;font-weight:700;}#yiv7969438658 dd.yiv7969438658last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7969438658 
dd.yiv7969438658last p span.yiv7969438658yshortcuts 
{margin-right:0;}#yiv7969438658 div.yiv7969438658attach-table div div a 
{text-decoration:none;}#yiv7969438658 div.yiv7969438658attach-table 
{width:400px;}#yiv7969438658 div.yiv7969438658file-title a, #yiv7969438658 
div.yiv7969438658file-title a:active, #yiv7969438658 
div.yiv7969438658file-title a:hover, #yiv7969438658 div.yiv7969438658file-title 
a:visited {text-decoration:none;}#yiv7969438658 div.yiv7969438658photo-title a, 
#yiv7969438658 div.yiv7969438658photo-title a:active, #yiv7969438658 
div.yiv7969438658photo-title a:hover, #yiv7969438658 
div.yiv7969438658photo-title a:visited {text-decoration:none;}#yiv7969438658 
div#yiv7969438658ygrp-mlmsg #yiv7969438658ygrp-msg p a 
span.yiv7969438658yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7969438658 
.yiv7969438658green {color:#628c2a;}#yiv7969438658 .yiv7969438658MsoNormal 
{margin:0 0 0 0;}#yiv7969438658 o {font-size:0;}#yiv7969438658 
#yiv7969438658photos div {float:left;width:72px;}#yiv7969438658 
#yiv7969438658photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv7969438658 
#yiv7969438658photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7969438658
  #yiv7969438658reco-category {font-size:77%;}#yiv7969438658 
#yiv7969438658reco-desc {font-size:77%;}#yiv7969438658 .yiv7969438658replbq 
{margin:4px;}#yiv7969438658 #yiv7969438658ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7969438658 #yiv7969438658ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7969438658 
#yiv7969438658ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7969438658 
#yiv7969438658ygrp-mlmsg select, #yiv7969438658 input, #yiv7969438658 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7969438658 
#yiv7969438658ygrp-mlmsg pre, #yiv7969438658 code {font:115% 
monospace;}#yiv7969438658 #yiv7969438658ygrp-mlmsg * 
{line-height:1.22em;}#yiv7969438658 #yiv7969438658ygrp-mlmsg #yiv7969438658logo 
{padding-bottom:10px;}#yiv7969438658 #yiv7969438658ygrp-msg p a 
{font-family:Verdana;}#yiv7969438658 #yiv7969438658ygrp-msg 
p#yiv7969438658attach-count span {color:#1E66AE;font-weight:700;}#yiv7969438658 
#yiv7969438658ygrp-reco #yiv7969438658reco-head 
{color:#ff7900;font-weight:700;}#yiv7969438658 #yiv7969438658ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv7969438658 #yiv7969438658ygrp-sponsor 
#yiv7969438658ov li a {font-size:130%;text-decoration:none;}#yiv7969438658 
#yiv7969438658ygrp-sponsor #yiv7969438658ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7969438658 
#yiv7969438658ygrp-sponsor #yiv7969438658ov ul {margin:0;padding:0 0 0 
8px;}#yiv7969438658 #yiv7969438658ygrp-text 
{font-family:Georgia;}#yiv7969438658 #yiv7969438658ygrp-text p {margin:0 0 1em 
0;}#yiv7969438658 #yiv7969438658ygrp-text tt {font-size:120%;}#yiv7969438658 
#yiv7969438658ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv7969438658 

  

Kirim email ke