goyang terus,, =IF((A1<4)+(A1>7),"Bukan"," A")
>semoga bermanfaat ________________________________ From: Khozhot <[email protected]> To: [email protected] Sent: Thu, December 17, 2009 11:22:50 AM Subject: Re: [belajar-excel] fungsi diantara Iseng juga ach, biar tambah rame xi...xi...xi... =IF((A1>=4)*(A1<=7),"A","Bukan !") TQ, ....Zhot On Thu, 17 Dec 2009 10:41:59 +0700, Mr. Kid <[email protected]> wrote: > Iseng-iseng pakai Choose() biar ramai. > > =Choose((a1>=4)*(a1<=7)+1,"Bukan","A") > > 2009/12/17 Agus Susanto <[email protected]> > >> >> >> Atau bisa juga pake IF dan And >> >> =IF(AND(A1>=4,A1<=7),"A"," Bukan") >> >> >> --- Pada *Kam, 17/12/09, hery wahyudi <[email protected]>* menulis: >> >> >> Dari: hery wahyudi <[email protected]> >> Judul: Re: [belajar-excel] fungsi diantara >> Kepada: [email protected] >> Tanggal: Kamis, 17 Desember, 2009, 8:38 AM >> >> >> >> >> Selamat Pagi, >> >> di B1==> =IF(OR(A1<4;A1>7);"Bukan";" A") >> >> CMIIW >> >> TQ >> >> Miturut PP 03 kados ingkang kaserat ing ngandap meniko: >> >> >> >> para pakar tanya doong >> >> >> fungsi yang sederhana apaya yaaa >> yang menunjukkan diantara 1 sampai 10 >> >> contoh : >> cell A1 =5 >> Cell B1=jika cell A1 diantara 4 sampai 7 diisi "A" jika bukan diantara >> itu >> (kurang dari 4 dan lebih dari 7 )diisi :"Bukan") >> >> tolong fungsinya sependek mungkin yaa kalo perlu di buatkan UDF >> >> thanks >> >> >> >> >> -- >> * Hery Wahyudi* >> >> >> ------------------------------ >> Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya >> sekarang!<http://id.mail.yahoo.com> >> >> -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ ------------------------------------ /---------------------------------------------------------------\ | bergabung ke milis (subscribe) | | kirim mail kosong ke: [email protected] | | | | posting ke milis | | kirim kan ke: [email protected] | | | | melihat file archive / mendownload lampiran | | http://www.mail-archive.com/[email protected]/ | | | | menhubungi moderators & owners: | | [email protected] | | | | ExcelWeb <http://opi.110mb.com/> | \---------------------------------------------------------------/Yahoo! Groups Links
