kalau menggunakan makro tentu harus mengetahui : 1. kriteria apa yang
diperlukan2. rumus rumus yang dipakai untuk memperoleh nilai yang diinginkan.
3. variabel2 yang diperlukan untuk memperoleh nilai yang diinginkan4. nilai
ketelitian ( bias ) antara nilai real dan nilai hasil perhitungan.sebaiknya
file excelnya di sertakan
To: [email protected]
From: [email protected]
Date: Thu, 23 Jun 2011 03:42:49 +0000
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: [email protected] [mailto:[email protected]]
On Behalf Of zainul ulum [yahoo]
Sent: Thursday, June 23, 2011 10:25 AM
To: [email protected]
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: [email protected] [mailto:[email protected]]
On Behalf Of Tauffik Effendi
Sent: Thursday, June 23, 2011 9:59 AM
To: [email protected]
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. *****
