Dear Pak Agung, Ikut nimbrung ya. Ada baiknya ilustrasinya dibuat sebagai tabel bantu, sehingga bisa dengan menggunakan kombinasi formula Index Match..
File Terlampir.. > Rekan Be-exceler > > Ada teman minta bantu membuatkan formula if berganda. > Yaitu hubungan If berganda terhadap hasil angka tahun yang berbeda-beda > > Contoh ilustrasi mendetail ada dalam lampiran > > Kiranya dari para member milis bisa bantu. > > Terimakasih banyak atas bantuannya. > > Wassalam > Agung Widodo > ____________ _________ _________ _________ _________ _________ _________ Notice : This e-mail (and any attachment) is strictly confidential and is intended only for the addressee(s)above. Is strictly prohibited to forward, print, copy, or otherwise reproduce this message that would allow it to be viewed by any individual not originally listed as a recipient(s). If you have received this e-mail in error, please immediately notify the sender and delete this message. The opinions expressed in this e-mail (and any attachment) are those of the individual sender and may not necessarily reflect the views of PT Pusri. ____________ _________ _________ _________ _________ _________ _________
Copy of Contoh Tabel Pesangon.xls
Description: MS-Excel spreadsheet