Dear Pak Adnan, Berikut saya coba bantu utk A/P aging report terlampir dgn menggunakan fungsi if & and utk masing2 kolom aging bucket sbb : 1. 30days / 1bln : =IF($H5<=30,$F5,"") 2. 90days / 3bln : =IF(AND($H5>30,$H5<=90),$F5,"") 3. 90-360 days / 3bln-1thn : =IF(AND($H5>90,$H5<=360),$F5,"") 4. 360-1800 days / 1-5thn : =IF(AND($H5>360,$H5<=1800),$F5,"") 5. 1800 days / 5thn : =IF($H5>1800,$F5,"")
Semoga bermanfaat & sesuai harapan. Best regards, Primas Adexa ________________________________ From: Adnan Abidin <[email protected]> To: [email protected] Sent: Thursday, March 13, 2014 10:09 AM Subject: ]] XL-mania [[ Menghitung Umur Hutang (koreksi) [1 Attachment] Dear XL Mania Bagaimana cara rumus menghitung umur hutang untuk cut date 31 Des 2013. Terimakasih atas bantuannya. Thanks Adnan
Solusi - Hitung Aging Hutang.xlsx
Description: application/tika-ooxml
