Pakai jebakan error mas, rumusnya dirubah menjadi
=IF(ISERROR(FIND("AJU",A5,1)),LEFT(A5,9),MID(A5,15,6))________________________________________ From: belajar-excel@yahoogroups.com [mailto:belajar-ex...@yahoogroups.com] On Behalf Of Aghoest Iwan Sent: Friday, February 19, 2010 1:11 PM To: belajar-excel@yahoogroups.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
