Walah kebalik, gini nih kalo gak lihat masalahnya langsung. Nanti deh
dilihat. Kalo salah dikoreksi lagi. hehehe.
=IF(CountIF(a5,"*AJU*"),Mid(a5,15,6),Left(a5,9))
On Fri, Feb 19, 2010 at 4:32 PM, Mr. Kid <mr.nm...@gmail.com> wrote:
> 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 <zainul_u...@yahoo.com>wrote:
>
>>
>>
>> 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 <belajar-excel%40yahoogroups.com>[mailto:
>> belajar-excel@yahoogroups.com <belajar-excel%40yahoogroups.com>]
>> On Behalf Of Aghoest Iwan
>> Sent: Friday, February 19, 2010 1:11 PM
>>
>> To: belajar-excel@yahoogroups.com <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
>>
>>
>>
>>
>
>
