]] XL-mania [[ Digest Number 2415

Microsoft Excel Community

Messages In This Digest (3 Messages)

1a.

Re: Hitung Angsuran From: bagus

1b.

Re: Hitung Angsuran From: Neriyanto Kho

2a.

Sort Data Pakai Rumus From: Antonius Almanda

View All Topics | Create New Topic

Messages

1a.

Re: Hitung Angsuran

Posted by: "bagus" bagus@kingjim.co.id   bagus4bls

Thu Jun 7, 2012 2:20 pm (PDT)

Dear Neri;

File terlampir semoga sesuai harapan.

Bagus


Sent from my Taxiphone®

----- Original Message -----
From: Neriyanto Kho
To: XL-mania@yahoogroups.com
Sent: Tuesday, June 05, 2012 3:55 PM
Subject: ]] XL-mania [[ Hitung Angsuran

Dear Suhu,

Terima kasih atas informasinya.
Ada tambahan sedikit mengenai data terlampir.

Mohon bantuannya lagi ya.

Rgds,

----------------------------------------------------------
From: bagus <bagus@kingjim.co.id>
To: XL-mania@yahoogroups.com
Sent: Tuesday, June 5, 2012 1:01 PM
Subject: Re: ]] XL-mania [[ Hitung Angsuran

Dear Neriyanto;

File terlampir semoga sesuai harapan

Bagus

Sent from my Taxiphone®
----- Original Message -----
From: Neriyanto Kho
To: XL-mania@yahoogroups.com
Sent: Monday, June 04, 2012 11:23 PM
Subject: ]] XL-mania [[ Hitung Angsuran

Dear Para master,

Mohon pencerahannya ni , da buntu.
Saya lagi buat datang perhitungan angsuran sbb :

=IF($I16=VLOOKUP($I16;$I$7:$I$9;1;0);($M$16-SUM($Q$16:$T$16))/21;0)

Kalo keterangan saya ganti jadi KPG , hasilnya kok tetap sama ya ?

Terima kasih.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

1b.

Re: Hitung Angsuran

Posted by: "Neriyanto Kho" neriyanto@yahoo.com   neriyanto

Thu Jun 7, 2012 2:20 pm (PDT)

Dear Para Suhu,

sangat membantu
Saya ada tambahan , saya sedang buat master tanggal tetapi ada beberapa tanggal yg tidak sesuai yg diinginkan.

Ada advise ?

Terima kasih

________________________________
From: bagus <bagus@kingjim.co.id>
To: XL-mania@yahoogroups.com
Sent: Wednesday, June 6, 2012 1:52 PM
Subject: Re: ]] XL-mania [[ Hitung Angsuran



Dear Neri;
 
File terlampir semoga sesuai harapan.
 
 
Bagus
 
Sent from my Taxiphone®
----- Original Message -----
>From: Neriyanto Kho
>To: XL-mania@yahoogroups.com
>Sent: Tuesday, June 05, 2012 3:55
PM
>Subject: ]] XL-mania [[ Hitung Angsuran
>
> 
>Dear Suhu,
>
>
>Terima kasih atas informasinya.
>Ada tambahan sedikit mengenai data terlampir.
>
>
>Mohon bantuannya lagi ya.
>
>
>Rgds,
>
>
>
>
>
>________________________________
> From: bagus <bagus@kingjim.co.id>
>To: XL-mania@yahoogroups.com
>Sent: Tuesday, June 5, 2012 1:01 PM
>Subject: Re: ]] XL-mania [[ Hitung Angsuran
>
>
>Dear Neriyanto;
> 
>File terlampir semoga sesuai harapan
> 
>Bagus
> 
>Sent from my Taxiphone®
>----- Original Message -----
>>From: Neriyanto Kho
>>To: XL-mania@yahoogroups.com
>>Sent: Monday, June 04, 2012 11:23 PM
>>Subject: ]] XL-mania [[ Hitung Angsuran
>>
>> 
>>Dear Para master,
>>
>>
>>Mohon pencerahannya ni , da buntu.
>>Saya lagi buat datang perhitungan angsuran sbb :
>>
>>
>>=IF($I16=VLOOKUP($I16;$I$7:$I$9;1;0);($M$16-SUM($Q$16:$T$16))/21;0)
>>
>>
>>Kalo keterangan saya ganti jadi KPG , hasilnya kok tetap sama ya
?
>>
>>
>>Terima kasih.
>>
>>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

2a.

Sort Data Pakai Rumus

Posted by: "Antonius Almanda" mantini05@gmail.com   mantini05

Thu Jun 7, 2012 2:20 pm (PDT)

Dear XL-mania

Saya sudah cari referensi ke berbagai penjuru dunia, tetapi masih belum
ketemu seperti yang saya harapkan.

Berikut ini saya kirimkan file. Kiranya file ini kembali dengan solusi dari
para XL-mania.

Terimakasih.

Salam XL,

Antonius

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

Recent Activity

•  53
  New Members

Visit Your Group

Yahoo! Groups

Small Business Group

Share experiences

with owners like you

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Find helpful tips

for Moderators

on the Yahoo!

Groups team blog.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Delay pada posting disebabkan sibuknya momods dan leletnya        |
| koneksi dengan ind***t. bwakakakaka....
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe