Terlampir contoh file Formula =IF(A2<18,"KANAK-KANAK",IF(AND(A2>17,A2<31),"REMAJA",IF(AND(A2>30,B2="L"),"BAPAK-BAPAK","IBU-IBU")))
--- On Tue, 2/19/13, excel717 <[email protected]> wrote: From: excel717 <[email protected]> Subject: ]] XL-mania [[ Membagi golongan 2 level To: [email protected] Date: Tuesday, February 19, 2013, 1:36 AM Mohon bantuannya para MASTER usia 1-17 masuk golongan Kanak-kanak ( tidak membedakan jenis kelamin L/P ) usia 17-30 masuk golongan Remaja ( tidak membedakan jenis kelamin L/P ) usia >30 jika Jenis kelamin L maka masuk golongan Bapak-bapak, jika jenis kelamin P maka masuk golongan Ibu-ibu yang menjadi permasalahan saya di kategori usia > 30 MOHON BANTUANNYA SEKIAN, JAZAKUMULLOHU KHOIROOTI WASA'AADATID DUNYA WAL AKHIROH
membagi golongan.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
