Pinjam formula Mr. Kid + Kolom Bantu...file terlampir. Salam,HK ----- Forwarded message ----- From: 'Mr. Kid' [email protected] [belajar-excel] <[email protected]>To: BeExcel <[email protected]>Sent: Wednesday, 29 August 2018, 8:47:40 PM GMT+7Subject: Re: [belajar-excel] Rumus Jumlah berdasarkan waktu
Begini
:=$F4*(COLUMN(A1)=MATCH($G$1-$G4,{0,31,61,92,121,151,181,210,241,271,301,331,361}))
Regards,Kid
On Wed, Aug 29, 2018 at 6:50 PM halak hita [email protected]
[belajar-excel] <[email protected]> wrote:
Dear para MasterMohon dibantu dalam lampiran berikut.apa rumus tepat dan yang
mudah dipahami agar data (yang diberi warna kdapat menyesuaikan otomatis
seiring berjalannya waktu
salamHH
Rumus Nilai Rentang Waktu (Aging) - Penjelasan.xlsx
Description: MS-Excel 2007 spreadsheet
