Dear Pak NangAgus,

Terima kasih atas pencerahannya dan mohon informasi perlu perbaikan tabelnya 
seperti apa ya…? Karena table tersebut sudah baku dari manufacture.

Terima kasih
Samsudin

From: [email protected] [mailto:[email protected]]
Sent: Saturday, November 21, 2015 9:41 AM
To: [email protected]
Subject: Re: [belajar-excel] Kapasitas AC



Dear Samsudin

Menggunakan formula vlookup lebih sederhana, tapi formula lookup
menggunakan batas minimum. untuk memperoleh hasil yang dimaksudkan
tabelnya perlu poerbaikan.
contoh formula: =VLOOKUP(G20,C16:D23,2)
akan menghasilkan 0,5 pk karena batas 1pk minimal 7000.

silahkan diubah sesuai kebutuhan

salam
NangAgus

On 11/21/15, Samsudin [email protected]<mailto:[email protected]> 
[belajar-excel]
<[email protected]<mailto:[email protected]>> wrote:
>
>
> 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? :
>
>
> [cid:[email protected]]
>
>
> Terima kasih atas bantuannya.
>
>
> Terima kasih
> Samsudin
>
>
>
>
> ----------------------------------------------------------
>
>
> 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.
>


---------------------------------------------------------------------------------------------------

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.

Kirim email ke