Dear Pak Odong Nando, Super sekali jadi simple formulanya, terima kasih banyak dan bisa berjalan di laptop saya.
Terima kasih Samsudin From: [email protected] [mailto:[email protected]] Sent: Saturday, November 21, 2015 4:25 PM To: [email protected] Subject: Bls: [belajar-excel] Kapasitas AC 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]<mailto:[email protected]> [belajar-excel]" <[email protected]<mailto:[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 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.

