RE: [belajar-excel] formula date

2013-05-28 Terurut Topik Muhammad Iqbal
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Mr. Kid Sent: Monday, May 27, 2013 11:49 AM To: BeExcel Subject: Re: [belajar-excel] formula date Formula : =IF(-(0L4),MIN(CEILING(--L4,7)/7,4),) Bagian : 0L4 - memastikan bahwa isi L4 selalu angka

RE: [belajar-excel] formula date

2013-05-26 Terurut Topik Muhammad Iqbal
penjelasannya saya ucapkan terima kasih Thanks Regard Muhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Mr. Kid Sent: Monday, May 20, 2013 11:34 PM To: BeExcel Subject: Re: [belajar-excel] formula date Coba Actual Week di cell N5

Re: [belajar-excel] formula date

2013-05-26 Terurut Topik Mr. Kid
:* Monday, May 20, 2013 11:34 PM *To:* BeExcel *Subject:* Re: [belajar-excel] formula date ** ** Coba Actual Week di cell N5 : =IF(-(0L4),MIN(CEILING(--L4,7)/7,4),) Wassalam, Kid. ** ** 2013/5/20 Muhammad Iqbal iq_bal7...@yahoo.com Hai mr kid, Terima

Re: [belajar-excel] formula date

2013-05-20 Terurut Topik Mr. Kid
*To:* BeExcel *Subject:* Re: [belajar-excel] formula date ** ** Hai Iqbal, Coba file terlampir. ** ** Yang perlu diperhatikan adalah dalam setiap proses perbandingan antara dua nilai dituntut sama persis. Pada dasarnya Excel menggunakan sifat case insensitive