Pake aja rumus sederhana ini : =1-DAYS360(Tanggal perencanaan,Tanggal actual)/360*2
1 atau 100% ---> nilai awal 2 atau 200% ---> range nilai ( dari 100% s/d -100% ) Kalo pake tabel sebenernya bisa juga tapi formulanya rumit masalahnya melibatkan formula interpolasi juga.. kalo nilainya pasti ada di tabel tidak ada masalah sih.. kalo nilainya tidak ada di tabel???? hasilnya gak akan akurat ( kalo tidak diinterpolasi ) Selain itu, Jumlah hari tiap tahun kan gak sama.. ntar hasilnya bisa beda.. lengkapnya lihat attachment aja, semoga berguna cheers VD "Nurcahyo, Aris" <[EMAIL PROTECTED]> Sent by: [email protected] 10/15/2008 05:02 PM Please respond to [email protected] To <[email protected]> cc Subject ]] XL-mania [[ mengitung persentase selisih tanggal Mas ... Mbak... XL-ers mohon bantuannya kembali ya rekan2 di Xl-mania, untuk kasus berikut. terimakasih Important: The information contained in this email is confidential and may be legally privileged. It is also subject to copyright. If you have received it in error, confidentiality and privilege are not waived and you must not disclose or use the information in it. Please notify the sender by return email and delete it from your system. Any unauthorised use is expressly prohibited. Please consider the environment before printing this e-mail.
<<image/gif>>
<<image/gif>>
Book3.xls
Description: MS-Excel spreadsheet
