On 11/06/2014 16:42, 'Bagus' [email protected] [XL-mania] wrote: > > > > 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] > <mailto:[email protected]%20[XL-mania]> > *To:* [email protected] <mailto:[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 > > thanks yach...
salam Rivo
