Re: [belajar-excel] Simple IF

[raya hidayat]

On Fri, Mar 9, 2012 at 8:21 AM, Mansor <dbpermatas...@gmail.com> wrote:

> **
>
>
>
> 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
>
>  
>



-- 
Terima kasih


Raya

Simple IF.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet