Hai Niky,
Coba formula :
=FLOOR(F4,LOOKUP(F4,{10,50,500}*10^6))*LOOKUP(F4,{10,50,500}*10^6,{5,5,10}/100)
untuk regional setting komputer Indonesia, kira-kira seperti ini :
=FLOOR(F4;LOOKUP(F4;{10\50\500}*10^6))*LOOKUP(F4;{10\50\500}*10^6;{5\5\10}/100)
Wassalam,
Kid.
On Fri, Oct 3, 2014 at 5: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.
>
>
