Dear Mr Zul,
Sori revisi :
=VLOOKUP(H8;$B$5:$E$13;4;)*I8+VLOOKUP(H8;$B$5:$E$13;4;)/IFERROR(IF(LEN(VLOOKUP(H8;$B$5:$E$13;3;))=9;LEFT(RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/";VLOOKUP(H8;$B$5:$E$13;3;)));FIND("/";RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/";VLOOKUP(H8;$B$5:$E$13;3;))))-1);MID(LEFT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))-1);FIND("/Pck";VLOOKUP(H8;$B$5:$E$13;3;))+4;50));MID(LEFT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))-1);FIND("/Rtg";VLOOKUP(H8;$B$5:$E$13;3;))+4;50))*J8+VLOOKUP(H8;$B$5:$E$13;4;)/VLOOKUP(H8;$B$5:$E$13;2;)*K8
Salam,
DD
From: Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]
Sent: 01 Juni 2015 15:22
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Rumus Total Harga
Dear Mr Zul,
Coba formula ini di cell L8 :
=VLOOKUP(H8;$B$5:$E$13;4;)*I8+VLOOKUP(H8;$B$5:$E$13;4;)/IFERROR(IF(LEN(VLOOKUP(H8;$B$5:$E$13;3;))=9;LEFT(RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/";VLOOKUP(H8;$B$5:$E$13;3;)));FIND("/";RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/";VLOOKUP(H8;$B$5:$E$13;3;))))-1);MID(LEFT(VLOOKUP(B5;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(B5;$B$5:$E$13;3;))-1);FIND("/Pck";VLOOKUP(B5;$B$5:$E$13;3;))+4;50));MID(LEFT(D5;FIND("/Pcs";D5)-1);FIND("/Rtg";D5)+4;50))*J8+VLOOKUP(H8;$B$5:$E$13;4;)/VLOOKUP(H8;$B$5:$E$13;2;)*K8
Dengan komposisi ke 5 jenis dibawah yah.
Semoga sesuai harapan.
Salam,
DD
From: Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]
Sent: 01 Juni 2015 13:38
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Rumus Total Harga
Dear Mr Zul,
Formula saya hanya bisa baca dengan komposisi yang mengandung karakter :
“/Pck” dan “Pcs” dalam satu cell, dan dengan komposisi “/Pcs” di akhir cell.
Mungkin agar lebih tepatnya ada berapa jenis komposisi pastinya ?
Contoh :
1. Dus30/Pck15/Pcs
2. Bal80/Pck20/Pcs
3. Dus30/Pcs
4. Ball30/Pck15/Pcs
5. Dus30/Rtg15/Pcs
6. ?
7. ?
8. ?
9. Dst...
Barulah akan ketahuan tepatnya formula untuk case tersebut.
Salam,
DD
From: Zulfikar N zulfikar_rout...@yahoo.com [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]
Sent: 01 Juni 2015 09:44
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Rumus Total Harga
Dear Master DD,
Sebelumnya di kolom Komposit Dus30/Pck15/Pcs, pertanyaan saya bagaimana jika
isi pada kolom komposit berisi Ball30/Pck15/Pcs, Dus30/Rtg15/Pcs, Dus30/Cup
dll. Mohon pencerahannya.
salam,
Zulfikar
Pada Jumat, 29 Mei 2015 14:49, "Dede pmaho_l...@nabatisnack.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear Mr Zul,
Coba formula ini di cell L8 :
=VLOOKUP(H8;$B$5:$E$13;4;)*I8+VLOOKUP(H8;$B$5:$E$13;4;)/IFERROR(MID(LEFT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))-1);FIND("/Pck";VLOOKUP(H8;$B$5:$E$13;3;))+4;50);LEFT(RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;)));FIND("/Pcs";RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))))-1))*J8+VLOOKUP(H8;$B$5:$E$13;4;)/VLOOKUP(H8;$B$5:$E$13;2;)*K8
Semoga sesuai harapan.
Salam,
DD
From: Zulfikar N zulfikar_rout...@yahoo.com [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]
Sent: 29 Mei 2015 09:57
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Rumus Total Harga [1 Attachment]
Dear Master,
Mohon bantuannya untuk kasus saya terlampir, rencananya saya akan membuat tools
sederhana untuk melihat total harga barang jika saya input di kolom kuantiti
barang sesuai orderan pelanggan akan terakumulasi total harganya.
Untuk lebih jelasnya bisa di lihat di file terlampir.
Terima kasih,
salam
Zulfikar
Palopo, Sulsel
_____
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. If you have
received this email in error please send it back to the person that sent it to
you. Any views or opinions presented are solely those of its author and do not
necessarily represent those of NABATI or any of its subsidiary companies.
Unauthorized publication, use, dissemination, forwarding, printing or copying
of this email and its associated attachments is strictly prohibited.
