=IF(LEFT(C2)=1,"Order No","Document No") Powered by Telkomsel BlackBerry®
-----Original Message----- From: Mansor <[email protected]> Sender: [email protected] Date: Fri, 9 Mar 2012 09:21:59 To: belajar-excel<[email protected]> Reply-To: [email protected] Subject: [belajar-excel] Simple IF Para teman dan guru BeExcel, Apabila reference no dimulai dgn angka 1, "Order No" dan jika angka 3 , "Document No" Mohon pencerahan agar rumus ini berhasil =IF(C2="1***","Order No","Document No") Terima kasih -Mansor Reference No Hasil yg diinginkan 100003571 Order No 100003573A Order No 100003578 Order No 100003579 Order No 100003581 Order No 3400088174 Document No 340008817411 Document No 34000881766 Document No 3400088174 Document No 34000881748 Document No 3400088175 Document No
