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.

