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: [email protected] [mailto:[email protected]] Sent: Tuesday, May 09, 2017 4:52 PM To: [email protected] 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
Description: FORMULA (IF) JIKA.xlsx
