Bisa pakai dynamic range… Sehingga tidak selalu merubah rangenya…
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Tauffik Effendi Sent: Thursday, June 23, 2011 11:19 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Terima kasih pak Zainul Namun kalo ada tambahan data baru tiap hari saya harus rubah formulanya tiap hari pak ya (untuk range-nya) Tadinya saya berharap ada formula untuk function sehingga tiap ada data baru tiap hari saya tinggal drag cell-nya kebawah Tapi utk data yg sdh tertentu pada range tertentu solver tadi bisa dipakai pak terimakasih From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of zainul ulum [yahoo] Sent: Thursday, June 23, 2011 11:08 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Dicoba pakai solver aja ya… Buat rumus di [CG3] =MIN(CG4:CG11) Setting solver sbb: Click solve…. From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Tauffik Effendi Sent: Thursday, June 23, 2011 10:57 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Terlampir rumusnya… pak Zainul Ditunggu bantuannya Terima-kasih From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of zainul ulum [yahoo] Sent: Thursday, June 23, 2011 10:50 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Kalo rumusnya tidak bisa share di milis, bisa pakai solver Kalo ada rumusnya bisa dishare (diketahui formulanya) pakai iterative calculation. From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Tauffik Effendi Sent: Thursday, June 23, 2011 10:43 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Terima kasih pak zainul Tapi file itu hanya contoh saja pak, karena perhitungan aslinya melibatkan banyak cell sehingga rumus B5=SQRT (250/C5) tidak dapat digunakan Ada yang bisa bantu ???? From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of zainul ulum [yahoo] Sent: Thursday, June 23, 2011 10:25 AM To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Function untuk Goal Seek Kalo dilihat dari rumusnya bisa nggak pakai goal seek: B5=SQRT(250/C5) Seandainya ada rumus yang lain bisa menggunakan fasilitas solver untuk multiple goal seek. Silahkan baca di http://cadex.wordpress.com/2011/01/08/gen-pmg-03-pemakaian-solver-untuk-multiple-goal-seek/ From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Tauffik Effendi Sent: Thursday, June 23, 2011 9:59 AM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Function untuk Goal Seek Dear All, Apakah ada yang bisa bantu saya membuat function goal seek di visual basic editor di file terlampir. Kalao saya record macro, goal seek harus dijalankan satu-persatu tiap cell atau langsung menjalankan secara keseluruhan. Diinginkan membuat function goal seek sehingga formulanya bisa di drag ke bawah jika ada data tambahan tiap hari… Terima-kasih atas bantuannya ***** This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. PT Pertamina (Persero) is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ***** ***** This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. PT Pertamina (Persero) is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ***** ***** This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. PT Pertamina (Persero) is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ***** ***** This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. PT Pertamina (Persero) is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. *****
<<image001.png>>
<<image002.jpg>>
<<image003.jpg>>
