[belajar-excel] Digest Number 2016

Milis Belajar Microsoft Excel Group

2 New Messages

Digest #2016

1a

Re: IF BERTINGKAT by "utthank abe" abe_utthank

2a

Re: Tanya Multiple sumif atau sum(if(if .. dst by "Muhamad Abdillah XA" muhamad_abdillah

Messages

1a

Re: IF BERTINGKAT

Thu Jan 10, 2013 2:08 am (PST) . Posted by:

"utthank abe" abe_utthank

aztga maaf pak. udah betul rumuznya bapak.

2013/1/10 Masbooqien booqien@yahoo.com>

> **
>
>
> tq
>
> --- In belajar-excel@yahoogroups.com, utthank abe wrote:
> >
> > Rumus asli
> > =IF(G2="x";"pass";IF(G2=0;G2-F2;IF(G2>F2;"Lunas
> > "&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))
> >
> > Rumus di modif
> > =IF(ISTEXT(G2);(IF(G2="x";"pass";0));IF(G2=0;G2-F2;IF(G2>F2;"Lunas
> > "&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))
> >
> > IF(G2=F2;"Lunas";G2-F2 --> y merah kok gak ngaruh ya :(
> >
> >
> > 2013/1/10 Masbooqien Al qodiriyah
> >
> > > **
> > >
> > >
> > > Assalamu`alaikum....
> > >
> > > Dear Exceller
> > >
> > > ada yang mau saya tanyakan tentang rumus IF bertingkat
> > > mohon bantuannya
> > >
> > > Terima kasih
> > >
> > > Wassalamu`alaikum..
> > >
> > >
> > >
> >
> >
> >
> > --
> > R125
> >
>
>
>

--
R125

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2a

Re: Tanya Multiple sumif atau sum(if(if .. dst

Thu Jan 10, 2013 3:32 am (PST) . Posted by:

"Muhamad Abdillah XA" muhamad_abdillah

Trimakasih banyak Pak Zainul & MS Jan Raisin, formulanya sangat membantu

BR//billy

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of zainul_ulum[at]yahoo[dot]com
Sent: Thursday, January 10, 2013 4:34 PM
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Tanya Multiple sumif atau sum(if(if .. dst

Pakai rumus formula array=
=SUM(COUNTIF($B$6:$B$15,"*"&D$8&"*"))

Untuk jelasnya, silahkan lihat file terlampir
-zainul-

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
On Behalf Of Muhamad Abdillah XA
Sent: Thursday, January 10, 2013 4:12 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Tanya Multiple sumif atau sum(if(if .. dst

Hi XL'ers,

Mohon bantuannya bagaimana untuk menterjemahkan "contain" dalam rumus sum if
multiple ini atau sum(if(if...
Terlampir contoh kasusnya

BR//billy

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

Visit Your Group

>

View All Topics

>

Create New Topic

>

27 New Members

>

We are making changes based on your feedback, Thank you !

Submit Feedback

>

The Yahoo! Groups Product Blog

Check it out!

>

GROUP FOOTER MESSAGE

---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke:
belajar-excel@yahoogroups.com

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

CHANGE SETTINGS

>

TERMS OF USE

>

UNSUBSCRIBE

>