Dear Nicky; Ubah dahulu A19 menjadi 500000000 dan B19 menjadi 50000000, sehingga tabel listing menjadi:
Kemudian ketik formulanya di G4 sebagai berikut: =IF(AND(F4>=25E7;F4<5E8);INT((F4-2E8)/5E7)*25E5;IF(F4>=1E9;INT((F4-5E8)/5E8)*5E7;0))+VLOOKUP(F4;$A$14:$B$19;2;1) Jangan lupa ganti tanda ; menjadi , jika regional setting komputer anda adalah English. Wasalam NangAgus On Fri, Oct 3, 2014 at 2:47 PM, [email protected] [belajar-excel] < [email protected]> wrote: > > > Dear Master Excel, > > > Mohon bantuannya bagaimana cara membuat tiering hadiah dengan tanpa > membuat tabel bantu yang panjang untuk menterjemahkan tiering hadiah. > > > > > > Regards, > > > Niky N > > > > ========================================================== > > Please consider the environment before printing this email. > > This message is confidential and may also be privileged. If you are not > the intended recipient, please notify me by return e-mail and delete this > message from your system. If you are not the intended recipient, any use by > you of this message is strictly prohibited. We reserve our right to pursue > any available legal action based on the prevailing laws due to any misuse > of this e-mail or information contained herein. > >
