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
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
:* 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
*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
4 matches
Mail list logo