Maaf kalau keliru, karena hanya lihat solusi mas Zainul (belum lihat filenya) =IF(CountIF(a5,"*AJU*"),Left(a5,9),Mid(a5,15,6))
tapi kalau ternyata yang diambil (pasti 6 karakter) ada di paling kanan, Mid() diganti jadi Right(a5,6) Kid. On Fri, Feb 19, 2010 at 1:37 PM, zainul ulum <[email protected]> wrote: > > > Pakai jebakan error mas, rumusnya dirubah menjadi > =IF(ISERROR(FIND("AJU",A5,1)),LEFT(A5,9),MID(A5,15,6)) > > ________________________________________ > From: [email protected] <belajar-excel%40yahoogroups.com>[mailto: > [email protected] <belajar-excel%40yahoogroups.com>] > On Behalf Of Aghoest Iwan > Sent: Friday, February 19, 2010 1:11 PM > > To: [email protected] <belajar-excel%40yahoogroups.com> > Subject: [belajar-excel] Fungsi IF dan FIND > > > > Dear all masters.. > Please help me.. fungsinya sepertinya simple, tapi kok tidak sesuai harapan > ya..? Malah jadi bingung.. (see file attached). > Jika ada logika yg kurang sempurna, mohon petunjuk para master excel.. > Trims n regards, > Iwan. > > __________ Information from ESET NOD32 Antivirus, version of virus > signature > database 4878 (20100218) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > >
