Re: ]] XL-mania [[ Schedule Quantity pengiriman

dear pak millis millis,...

 

 

maaf cuma formula

dibuat hanya di SATU CELL (TopLeftCorner - nya  Data JadwalPengiriman)

lalu di 'drag' ke (BottomRightCorner -nya Data JadwalPengiriman)

 

(1)
=IF($F7-SUM($H7:H7)-SUM(I$6:I6)>=$D7,$D7-SUM(I$6:I6),
 IF($F7-SUM($H7:H7)-SUM(I$6:I6)<=0,0,$F7-SUM($H7:H7)))

 

Diperlukan 1 Kolom kosong dan 1 Baris kosong SEBELUM range tempat formula

ditulisikan; yg kemudian dapat di-HIDE.

 

Area formula perlu di [format number] tertentu agar hasil nol tidak ditampakkan

misal custom-number-format  0;0;; atau "acounting"

 

 

 

 

----- Original Message -----
From: millis millis
To: XL-mania@yahoogroups.com
Sent: Friday, October 23, 2009 02:53PM
Subject: ]] XL-mania [[ Schedule Quantity pengiriman

Dear teman2...
Mohon bantuan bikin rumus muncul quantity pengiriman secara otomatis dong...
klo bisa yg simple2 aja...
thanks sebelumya
File di attachment