alternatif saja, yang walaupun sedikit lebih panjang dari kreasi Bang Abi, tapi yang ini bukan array formula, jadi gak perlu menghadirkan CSE
cukup sebut nama saya, ZAMPRODUCT =(SUMPRODUCT((D8:M8>=19/24)*(MOD(COLUMN(D8:M8),2)=1))-SUMPRODUCT((D8:M8>9/24 )*(MOD(COLUMN(D8:M8),2)=0))-SUMPRODUCT((D8:M8<17/24)*(MOD(COLUMN(D8:M8),2)=1 )))*20000 -zam- <http://wongmbatu.blogspot.com/> http://wongmbatu.blogspot.com/ _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of abimono Sent: Wednesday, July 23, 2008 6:18 PM To: [email protected] Subject: Re: ]] XL-mania [[ Insentif / Pemotongan hai pak __ __ /| `,' |\ /_| | |_\ | | | |_______| formula dan penjelasan ada di dalam di P8 tulis: {=(SUM(MOD(COLUMN(C8:L8),2)*(-(D8:M8>9/24)))+SUM(MOD(COLUMN(C8:L8),2)*(-(E8: N8<17/24)))+SUM(MOD(COLUMN(C8:L8),2)*(--(E8:N8>19/24))))*20000}
Copy of Copy of Insentif Pemotongan.xls
Description: MS-Excel spreadsheet
