[belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]

Milis Belajar Excel mailing list
Assalamualaikum Wr. Wb.Para Master
Bagaimana formula (IF) pada kolom"D" jika criteria yangdibutuhkan adalah huruf pertama yang ada pada kolom "B" Misal G11852 = 16.33 atau B0404213=13.06, bila diisi manual seperti pada Kolom "C" dan bila dapat denganformula (IF) maka pada kolom "D" sama dengan kolom "C"dengan banyak data pada kolom "B" seperti data terlampir
TerimakasihWassalamualaikum Wr. Wb.
Hairul Alam

FORMULA (IF) JIKA.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]

Milis Belajar Excel mailing list
Dear Hairul Alam,
Jika kriteria hurup awalnya hanya G dan B, maka menurut saya kombinasi if dan left adalah solusinya.
Terlampir file solusinya, apakah sudah sesuai dengan yang dimaksud?

Salam, Rasyid

From: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, May 09, 2017 4:52 PM
To: [hidden email]
Subject: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]


Assalamualaikum Wr. Wb.
Para Master

Bagaimana formula (IF) pada kolom "D" jika criteria yang dibutuhkan adalah huruf pertama yang ada pada kolom "B" Misal G11852 = 16.33 atau B0404213 = 13.06, bila diisi manual seperti pada Kolom "C" dan bila dapat dengan formula (IF) maka pada kolom "D" sama dengan kolom "C" dengan banyak data pada kolom "B" seperti data terlampir

Terimakasih
Wassalamualaikum Wr. Wb.

Hairul Alam

Disclaimer   -   This  message  including any attachments and information contained
herein  ("Message" ) may contain  privileged information  or otherwise is protected
from  disclosure. Any  unauthorized use of this  Message  by any person may lead to
legal consequences.  If  you  receive this   Message  in error, or if the recipient
of this  Message  is not the intended recipient or the employee or agent authorized
for delivering this  Message to the intended recipient you are hereby notified that
any  disclosure,  dissemination, distribution  or copying of this Message or let or
cause this Message to be disclosed,disseminated, distributed, or copied is strictly
prohibited, and please notify the sender by  return message  and immediately delete
this  Message  from your system.   Incoming and outgoing  communications using this
electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
law and regulations. Unless it is made by the authorized person,any views expressed
in this Message  are those of the individual sender and may not necessarily reflect
the views of PT Arutmin Indonesia.
You should check attachments for viruses and defects before opening or using them.
We are not liable to recover any injuries caused by virused or defected attachments.


FORMULA (IF) JIKA.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Mungkin dengan formula lookup .



ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Tuesday, May 9, 2017 3:52 PM
*To:* [hidden email]
*Subject:* [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan
Angka [1 Attachment]





Assalamualaikum Wr. Wb.

Para Master



Bagaimana formula (IF) pada kolom "D" jika criteria yang dibutuhkan adalah
huruf pertama yang ada pada kolom "B" Misal G11852 = 16.33 atau B0404213 =
13.06, bila diisi manual seperti pada Kolom "C" dan bila dapat dengan
formula (IF) maka pada kolom "D" sama dengan kolom "C" dengan banyak data
pada kolom "B" seperti data terlampir



Terimakasih

Wassalamualaikum Wr. Wb.



Hairul Alam



image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
FORMULA (IF) JIKA-edited.xlsx (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka

Milis Belajar Excel mailing list
Terimakasih Banyak Pencerahannya Mr. Rasyid


    Pada Selasa, 9 Mei 2017 18:15, "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]> menulis:



     Mungkin dengan formula lookup . ade From: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, May 9, 2017 3:52 PM
To: [hidden email]

Subject: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]   Assalamualaikum Wr. Wb.Para Master Bagaimana formula (IF) pada kolom "D" jika criteria yang dibutuhkan adalah huruf pertama yang ada pada kolom "B" Misal G11852 = 16.33 atau B0404213 = 13.06, bila diisi manual seperti pada Kolom "C" dan bila dapat dengan formula (IF) maka pada kolom "D" sama dengan kolom "C" dengan banyak data pada kolom "B" seperti data terlampir TerimakasihWassalamualaikum Wr. Wb. Hairul Alam  #yiv9802877519 #yiv9802877519 -- #yiv9802877519ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9802877519 #yiv9802877519ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9802877519 #yiv9802877519ygrp-mkp #yiv9802877519hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9802877519 #yiv9802877519ygrp-mkp #yiv9802877519ads {margin-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad {padding:0 0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad p {margin:0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad a {color:#0000ff;text-decoration:none;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc {font-family:Arial;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc #yiv9802877519hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc .yiv9802877519ad {margin-bottom:10px;padding:0 0;}#yiv9802877519 #yiv9802877519actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9802877519 #yiv9802877519activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9802877519 #yiv9802877519activity span {font-weight:700;}#yiv9802877519 #yiv9802877519activity span:first-child {text-transform:uppercase;}#yiv9802877519 #yiv9802877519activity span a {color:#5085b6;text-decoration:none;}#yiv9802877519 #yiv9802877519activity span span {color:#ff7900;}#yiv9802877519 #yiv9802877519activity span .yiv9802877519underline {text-decoration:underline;}#yiv9802877519 .yiv9802877519attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9802877519 .yiv9802877519attach div a {text-decoration:none;}#yiv9802877519 .yiv9802877519attach img {border:none;padding-right:5px;}#yiv9802877519 .yiv9802877519attach label {display:block;margin-bottom:5px;}#yiv9802877519 .yiv9802877519attach label a {text-decoration:none;}#yiv9802877519 blockquote {margin:0 0 0 4px;}#yiv9802877519 .yiv9802877519bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9802877519 .yiv9802877519bold a {text-decoration:none;}#yiv9802877519 dd.yiv9802877519last p a {font-family:Verdana;font-weight:700;}#yiv9802877519 dd.yiv9802877519last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9802877519 dd.yiv9802877519last p span.yiv9802877519yshortcuts {margin-right:0;}#yiv9802877519 div.yiv9802877519attach-table div div a {text-decoration:none;}#yiv9802877519 div.yiv9802877519attach-table {width:400px;}#yiv9802877519 div.yiv9802877519file-title a, #yiv9802877519 div.yiv9802877519file-title a:active, #yiv9802877519 div.yiv9802877519file-title a:hover, #yiv9802877519 div.yiv9802877519file-title a:visited {text-decoration:none;}#yiv9802877519 div.yiv9802877519photo-title a, #yiv9802877519 div.yiv9802877519photo-title a:active, #yiv9802877519 div.yiv9802877519photo-title a:hover, #yiv9802877519 div.yiv9802877519photo-title a:visited {text-decoration:none;}#yiv9802877519 div#yiv9802877519ygrp-mlmsg #yiv9802877519ygrp-msg p a span.yiv9802877519yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9802877519 .yiv9802877519green {color:#628c2a;}#yiv9802877519 .yiv9802877519MsoNormal {margin:0 0 0 0;}#yiv9802877519 o {font-size:0;}#yiv9802877519 #yiv9802877519photos div {float:left;width:72px;}#yiv9802877519 #yiv9802877519photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9802877519 #yiv9802877519photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9802877519 #yiv9802877519reco-category {font-size:77%;}#yiv9802877519 #yiv9802877519reco-desc {font-size:77%;}#yiv9802877519 .yiv9802877519replbq {margin:4px;}#yiv9802877519 #yiv9802877519ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9802877519 #yiv9802877519ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9802877519 #yiv9802877519ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9802877519 #yiv9802877519ygrp-mlmsg select, #yiv9802877519 input, #yiv9802877519 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9802877519 #yiv9802877519ygrp-mlmsg pre, #yiv9802877519 code {font:115% monospace;}#yiv9802877519 #yiv9802877519ygrp-mlmsg * {line-height:1.22em;}#yiv9802877519 #yiv9802877519ygrp-mlmsg #yiv9802877519logo {padding-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-msg p a {font-family:Verdana;}#yiv9802877519 #yiv9802877519ygrp-msg p#yiv9802877519attach-count span {color:#1E66AE;font-weight:700;}#yiv9802877519 #yiv9802877519ygrp-reco #yiv9802877519reco-head {color:#ff7900;font-weight:700;}#yiv9802877519 #yiv9802877519ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov li a {font-size:130%;text-decoration:none;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov ul {margin:0;padding:0 0 0 8px;}#yiv9802877519 #yiv9802877519ygrp-text {font-family:Georgia;}#yiv9802877519 #yiv9802877519ygrp-text p {margin:0 0 1em 0;}#yiv9802877519 #yiv9802877519ygrp-text tt {font-size:120%;}#yiv9802877519 #yiv9802877519ygrp-vital ul li:last-child {border-right:none !important;}#yiv9802877519


Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Terimakasih banyak pencerahannya Mr.Ade


    Pada Selasa, 9 Mei 2017 18:15, "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]> menulis:



     Mungkin dengan formula lookup . ade From: [hidden email] [mailto:[hidden email]]

Sent: Tuesday, May 9, 2017 3:52 PM
To: [hidden email]
Subject: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1 Attachment]   Assalamualaikum Wr. Wb.Para Master Bagaimana formula (IF) pada kolom "D" jika criteria yang dibutuhkan adalah huruf pertama yang ada pada kolom "B" Misal G11852 = 16.33 atau B0404213 = 13.06, bila diisi manual seperti pada Kolom "C" dan bila dapat dengan formula (IF) maka pada kolom "D" sama dengan kolom "C" dengan banyak data pada kolom "B" seperti data terlampir TerimakasihWassalamualaikum Wr. Wb. Hairul Alam  #yiv9802877519 #yiv9802877519 -- #yiv9802877519ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9802877519 #yiv9802877519ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9802877519 #yiv9802877519ygrp-mkp #yiv9802877519hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9802877519 #yiv9802877519ygrp-mkp #yiv9802877519ads {margin-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad {padding:0 0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad p {margin:0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad a {color:#0000ff;text-decoration:none;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc {font-family:Arial;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc #yiv9802877519hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc .yiv9802877519ad {margin-bottom:10px;padding:0 0;}#yiv9802877519 #yiv9802877519actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9802877519 #yiv9802877519activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9802877519 #yiv9802877519activity span {font-weight:700;}#yiv9802877519 #yiv9802877519activity span:first-child {text-transform:uppercase;}#yiv9802877519 #yiv9802877519activity span a {color:#5085b6;text-decoration:none;}#yiv9802877519 #yiv9802877519activity span span {color:#ff7900;}#yiv9802877519 #yiv9802877519activity span .yiv9802877519underline {text-decoration:underline;}#yiv9802877519 .yiv9802877519attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9802877519 .yiv9802877519attach div a {text-decoration:none;}#yiv9802877519 .yiv9802877519attach img {border:none;padding-right:5px;}#yiv9802877519 .yiv9802877519attach label {display:block;margin-bottom:5px;}#yiv9802877519 .yiv9802877519attach label a {text-decoration:none;}#yiv9802877519 blockquote {margin:0 0 0 4px;}#yiv9802877519 .yiv9802877519bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9802877519 .yiv9802877519bold a {text-decoration:none;}#yiv9802877519 dd.yiv9802877519last p a {font-family:Verdana;font-weight:700;}#yiv9802877519 dd.yiv9802877519last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9802877519 dd.yiv9802877519last p span.yiv9802877519yshortcuts {margin-right:0;}#yiv9802877519 div.yiv9802877519attach-table div div a {text-decoration:none;}#yiv9802877519 div.yiv9802877519attach-table {width:400px;}#yiv9802877519 div.yiv9802877519file-title a, #yiv9802877519 div.yiv9802877519file-title a:active, #yiv9802877519 div.yiv9802877519file-title a:hover, #yiv9802877519 div.yiv9802877519file-title a:visited {text-decoration:none;}#yiv9802877519 div.yiv9802877519photo-title a, #yiv9802877519 div.yiv9802877519photo-title a:active, #yiv9802877519 div.yiv9802877519photo-title a:hover, #yiv9802877519 div.yiv9802877519photo-title a:visited {text-decoration:none;}#yiv9802877519 div#yiv9802877519ygrp-mlmsg #yiv9802877519ygrp-msg p a span.yiv9802877519yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9802877519 .yiv9802877519green {color:#628c2a;}#yiv9802877519 .yiv9802877519MsoNormal {margin:0 0 0 0;}#yiv9802877519 o {font-size:0;}#yiv9802877519 #yiv9802877519photos div {float:left;width:72px;}#yiv9802877519 #yiv9802877519photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9802877519 #yiv9802877519photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9802877519 #yiv9802877519reco-category {font-size:77%;}#yiv9802877519 #yiv9802877519reco-desc {font-size:77%;}#yiv9802877519 .yiv9802877519replbq {margin:4px;}#yiv9802877519 #yiv9802877519ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9802877519 #yiv9802877519ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9802877519 #yiv9802877519ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9802877519 #yiv9802877519ygrp-mlmsg select, #yiv9802877519 input, #yiv9802877519 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9802877519 #yiv9802877519ygrp-mlmsg pre, #yiv9802877519 code {font:115% monospace;}#yiv9802877519 #yiv9802877519ygrp-mlmsg * {line-height:1.22em;}#yiv9802877519 #yiv9802877519ygrp-mlmsg #yiv9802877519logo {padding-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-msg p a {font-family:Verdana;}#yiv9802877519 #yiv9802877519ygrp-msg p#yiv9802877519attach-count span {color:#1E66AE;font-weight:700;}#yiv9802877519 #yiv9802877519ygrp-reco #yiv9802877519reco-head {color:#ff7900;font-weight:700;}#yiv9802877519 #yiv9802877519ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov li a {font-size:130%;text-decoration:none;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9802877519 #yiv9802877519ygrp-sponsor #yiv9802877519ov ul {margin:0;padding:0 0 0 8px;}#yiv9802877519 #yiv9802877519ygrp-text {font-family:Georgia;}#yiv9802877519 #yiv9802877519ygrp-text p {margin:0 0 1em 0;}#yiv9802877519 #yiv9802877519ygrp-text tt {font-size:120%;}#yiv9802877519 #yiv9802877519ygrp-vital ul li:last-child {border-right:none !important;}#yiv9802877519