Pak Samsudin, Contoh formula konversi satuan seperti file yang ada disini <https://app.box.com/s/yrifge66jwl4707vp8zx639oket6689n>. Data validation list bertingkat bisa dilihat disini <http://excel-mr-kid.blogspot.co.id/2015/11/data-validation-list-3-banyak-tingkat.html>, tetapi sebaiknya dimulai dari sini <http://excel-mr-kid.blogspot.co.id/2015/11/data-validation-list-1-pengantar.html> .
Wassalam, Kid On Sat, Nov 21, 2015 at 2:51 PM, Samsudin samsu...@bayan.com.sg [belajar-excel] <belajar-excel@yahoogroups.com> wrote: > > > Dear Master Excel, > > > > Saya punya masalah dengan formula untuk buat template satuan panjang, > tekanan, dan energy (file terlampir). Bagiamana formulanya untuk bisa > secara otomatis jika saya memilih pada cell f2, kemudian saya memilih lagi > cell h2, kemudian saya menginput nilai pada cell g2, sehingga saya akan > mendapatkan nilai otomatis muncul (berubah-ubah) sesuai pilihan pada cell > h4, dimana acuannya ada pada cell b12 :d20. > > > > Sebelumnya saya mengucapkan banyak terima kasih dan sebagai informasi pada > kasus ini saya sudah menggunakan formula dari Mba Siti > (Alm)_dynamic_dropdownlist. > > > > *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. > > >