Hai Rivo;
Coba rubah sedikit formula yang ada: =LOOKUP(2,1/H3:H11,H3:H11) menjadi: =LOOKUP(2,1/(H3:H11>=0),H3:H11) Wassalam ~ Bagus ~ ----- Original Message ----- From: rivo [email protected] [XL-mania] To: [email protected] Sent: Wednesday, June 04, 2014 12:11 AM Subject: ]] XL-mania [[ Cari Saldo / angka terakhir [1 Attachment] Dear par master, mhn petunjuk kenapa di rumus mencari saldo akhir tidak membaca saldo dengan angka 0? see attach. thanks Rivo
