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 samsu...@bayan.com.sg [belajar-excel] <belajar-excel@yahoogroups.com> 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:image002.png@01D12428.694FE330] > > > 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. >
